12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

Published on: 27/09/2019
Database Concepts
Download Tamil Nadu 12th Standard Computer Science question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.
Questions + Answers key
Take MCQ Computer Science Test

1.
Write a note on
(i) SELECT Operation
(ii) PROJECT Operation
2.
List the types of RDBMS software.
3.
List the characteristics of DBMS.
4.
Differentiate data and information.
5.
What is database?
6.
What is normalization?
7.
What is the difference between Hierarchical and Network data model?
8.
What is data consistency?
9.
List some examples of RDBMS.
10.
Mention few examples of a database.
1.
(i) SELECT Operation (symbol : σ): The SELECT operation is used for selecting a subset with tuples according to a given condition.
(ii) PROJECT Operation (symbol: II): The projection eliminates all attributes of the input relation but those mentioned in the projection list. The projection method defines a relation that contains a vertical subset of Relation.
2.
SQL server, Oracle, MySQL, MariaDB, SQLite.
3.
DBMS Supports Transactions : It allows us to better handle and manage data integrity in real world applications where multi-threading is extensively used.
4.
(i) Data are raw facts stored in a computer. A data may contain any character, text, word or a number.
(ii) Information is formatted data, which allows to be utilized in a significant way.
5.
(i) Database is a repository collection of related data organized in a way that data can be easily accessed, managed and updated.
(ii) Database can be a soft ware or hardware based, with one sole purpose of storing data.
6.
Database normalization was first proposed by Dr.Edgar F Codd as an integral part of RDBMS in order to reduce data redundancy and improve data integrity. These rules are known as E FCodd Rules.
7.
| Hierarichal data Model | Network data model |
| In Hierarchical model, a child record has only one parent node | In a Network model, a child may have many parent nodes, |
| It Hierarchical model, data is represented as a simple tree like structure form. | It represents the data in many-to-many lationships. |
8.
Data Consistency means that data values are the same at all instances of a database.
9.
(i) SQL server
(ii) Oracle
(iii) MySql
(iv) Maria DB
(v) SQLite.
10.
(i) Foxpro
(ii) dbase
12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications களப்பெயர் முறைமை (DNS) Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு எடுத்துக்காட்டுகள் மற்றும் நெறிமுறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications கணினி வலையமைப்பு ஓர் அறிமுகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications PHP-உடன் MySQL-ஐ இணைத்தல் Sample Question Papers Study Material - QB365 Set A
Tamilnadu Stateboard 12th Standard Subjects

Maths

Chemistry

Physics

Biology

Computer Science

Business Maths and Statistics

Economics

Commerce

Accountancy

History

Computer Applications

Biology

Computer Technology

Computer Applications

Computer Science

Business Maths and Statistics

Commerce

Economics

Maths

Chemistry

Physics

Computer Technology

History

Accountancy

Tamil

English

French
Tamilnadu Stateboard Standards