12-C October -2017 Monthly Test Blue-Print

12th-C October -2017 Monthly Test Blue-Print .  Max Marks:  35marks , Duration : 1 Hour 30minutes
Date: 31/10/2017  Time: 1.00PM to 2.30PM

I DBMS Concepts-  11 marks

*  Relational model, Tupple, Attribute, Degree, Cardinality,  Selectioon(   ), Projection (π),  Candidate Key, Primary Key, Alternate Key, Foriegn Key, Relational Algebra: Union, Intersection, cartesian product, difference.

a) Any two concepts as per the board pattern- 2+2=4 marks

b) Any two concepts as per the board pattern- 2 marks

c) Any two concepts as per the board pattern- 2+1=3 marks

d) Any two concepts as per the board pattern- 2 marks

SQL COMMANDS : CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE...SET...,INSERT, DELETE;
SLECT, DISTINCT, FROM WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY;

SQL FUNCTIONS: SUM, AVG, COUNT, MAX and MIN

II SQL  4+2 =6+6=12 marks   (As per the Board Pattern)
Table1 and Table2

a) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
b) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
c) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
d) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark

e) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
f) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
g) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
h) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark

III SQL  4+2 =6+6=12 marks   (As per the Board Pattern) (one more set  as per IInd Question)
Table1 and Table2

a) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
b) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
c) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
d) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark

e) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
f) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
g) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
h) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark