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: 06/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.
2.
A tuple is also known as
table
row
attribute
field
3.
What symbol is used for SELECT statement?
σ
Π
X
Ω
4.
Who is called Father of Relational Database from the following?
Chris Date
Hugh Darween
Edgar Frank Codd
Edgar Frank Cadd
5.
What is the acronym of DBMS?
DataBase Management Symbol
Database Managing System
DataBase Management System
DataBasic Management System
6.
What is normalization?
7.
What is the difference between Hierarchical and Network data model?
8.
What is data consistency?
9.
Write a note on different types of DBMS users.
10.
Explain Object Model with example.
11.
12.
Explain the characteristics of DBMS.
13.
Explain the different operators in Relational algebra with suitable examples.
1.
(a)
2.
(b)
row
3.
(a)
σ
4.
(c)
Edgar Frank Codd
5.
(c)
DataBase Management System
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.
Database Administrators:
Database Administrator or DBA is the one who manages the complete database management system. DBA takes care of the security of the DBMS, managing the license keys, managing user accounts and access etc.
Application Programmers or software Developers:
This user group is involved in developing and designing the parts of DBMS.
End User:
All modern applications, web or mobile, store user data. Applications are programmed in such a way that they collect user data and store the data on DBMS systems running on their server. End users are the one who store, retrieve, update and delete data.
Database designers:
Database designers are responsible for identifying the data to be stored in the database for choosing appropriate structures to represent and store the data.
10.
Object model stores the data in the form of objects, attributes and methods, classes and inheritance. This model handles more complex applications, such as Geographic information System (GIS),sdentific experiments, engineering design and manufacturing. It is used in file Management System. It represents real world objects, attributes and behaviors. It provides a clear modular structure. It is easy to maintain and modify the existing code.
An example of the Object model is Shape, Circle, Rectangle and Triangle are all objects in this model
(i) Circle has the attribute radius.
(ii) Rectangle has the attributes length and breadth.
(iii) Triangle has the attributes base and height.
(iv) The objects Circle, Rectangle and. Triangle inherit from the object Shape
11.
12.
Characteristics of Database Management System
| 1. Data stored into Table | Data is never directly stored into the database. Data is stored into tables, created inside the database. DBMS also allows to have relationship between tables which makes the data more meaningful and connected. |
| 2. Reduced Redundancy | In the modern world hard drives are very cheap, but earlier when hard drives were too expensive, unnecessary repetition of data in database was a big problem But DBMS follows Normalisation which divides the data in such a way that repetition is minimum. |
| 3. Date Consistency | On live data, it is being continuously updated and added, maintaining the consistency of data can become a challenge. But DBMS handles it by itself. |
| 4. Support Multiple user and Concurrent Access | DBMS allows multiple users to work on it( update, insert, delete data) at the same time and still manages to maintain the data consistency. |
| 5. Query Language | DBMS provides users with a simple query language, using which data can be easily fetched, inserted, deleted and updated in a database. |
| 6. Security | The DBMS also takes care of the security of data, protecting the data from unauthorized access. In a typical DBMS, we can create user accounts with different access permissions, using which we can easily secure our data by restricting user access. |
| 7. DBMS Supports Transactions | It allows us to better handle and manage data integrity in real world applications where multi-threading is extensively used. |
13.
Relational Algebra is divided into various groups
Unary Relational Operations.
(i) SELECT (symbol: σ)
(ii) PROJECT ( symbol: π)
Relational Algebra Operations from Set Theory:
(i) UNION (U)
(ii) INTERSECTION (∩)
(iii) DIFFERENCE (-)
(iv) CARTESIAN PRODUCT (X)
SELECT (symbol: σ)
(i) General from σ (R) with a relation R and a condition C on the attributes of R
(ii) The SELECT operation is used for selecting a subset with tuples according to a given condition.
(iii) Select filters out all tuples that do not satisfy C
STUDENT:
| Studio | Name | Course | Year |
|---|---|---|---|
| CS1 | Kannan | Big Data | II |
| CS2 | Gowri Shankar | R language | I |
| CS3 | Lenin | Big Data | I |
| CS4 | Padmaja | Python Programming | I |
σ course = "Big Data" (STUDENT)
| Studio | Name | Course | Year |
|---|---|---|---|
| CS1 | Kannan | Big Data | II |
| 2 | Lenin | Big Data | I |
PROJECT (symbol: II)
(i) The projection eliminates all attributes of the input relation but those mentioned in the projection list.
(ii) The projection method defines a relation that contains a vertical subset of Relation.
Example: 1
IIcourse (STUDENT)
Result:
| Course |
| Big Data |
| R language |
| Python Programming |
Example 2
IIstudent,course (STUDENT)
Result:
| Stud no | Course |
| CS1 | Big Data |
| CS2 | R language |
| CS3 | Big Data |
| CS4 | Python Programming |
UNION (Symbol: U)
(i) It includes all tuples that are in tables A or in B. It also eliminates duplicates. Set A Union Set B would be expressed as A U B
Example 3:
| Table A | |
|---|---|
| Studio | Name |
| CS1 | Kannan |
| CS2 | Lenin |
| CS3 | Padmaja |
| Table A | |
|---|---|
| Studio | Name |
| CS1 | Kannan |
| CS2 | Gowrishakaran |
| CS3 | Lenin |
Result:
| Table A | |
|---|---|
| Studio | Name |
| CS1 | Kannan |
| CS2 | Gowri Shakaran |
| CS3 | Lenin |
| CS4 | Padmaja |
SET DIFFERENCE (Symbol: -)
(i) The result of A - B, is a relation which includes all tuples that are in A but not in B.
(ii) The attribute name of A has to match with the attribute name in B.
Example: 4
using Table B Example 3
Result:
| Table A - B | |
|---|---|
| CS4 | Padmaja |
INTERSECTION (symbol: ∩) A ∩ B:
(i) Defines a relation consisting of a set of all tuple that are in both in A and B. However, A and.B must be union-compatible.
Example: 5
Using Table in Example 3
Result:
| Table A - B | |
|---|---|
| CS1 | Kannan |
| CS3 | Lenin |
PRODUCT OR CARTESIAN PRODUCT (Symbol: X)
(i) Cross product is a way of combining two relations. The resulting relation contains, both relations being combined.
(ii) A x B means A times B, where the relation A and B have different attributes.
(iii) This type of operation is helpful to merge columns from two relations.
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