12th September test-2018 Blue Print

 Boolean Algebra-16 marks

1)  Boolean  Circuit to Expression -2 mark

2)  Boolean  Expression to Circuit : 2 marks

3)  Writing   SOP Expression Expression (3 variables):1 mark 

4)  Writing   POS Expression (3 variables): 1 mark 

5)  Boolean Laws(10+1) verification (truth table/Laws): 2 marks

6)  Boolean Laws(10+1) verification (truth table/Laws): 2 marks

7)  K-Map simplify SOP expresiion: 3 marks

8)  k-Map simplify POS  expression: 3 marks

 DBMS Concepts- (15 marks)
                  Two Table

1) Relational model- 1mark                         2) Tupple - 1mark               3) Attribute - 1 mark, 

4)Degree-1mark                                         5) Cardinality                        6)Selectioon(   ) 1mark

7) Projection (π)- 1 mark                            8) Candidate Key - 1mark    9) Primary Key  1mark

10) Alternate Key- 1mark                           11) Foriegn Key - 1 mark      

 Relational Algebra:       12) Union  - 1mark      13) Intersection - 1mark 

14)Cartesian product - 1 mark          15) Difference - 1 mark


SQL COMMANDS : (4 marks)

1) CREATE TABLE - 2 marks     2) ALTER TABLE,- 2 marks


create table name of the table

(

 colum1 datatype,

 colum2 datatype,

 colum3 datatype,

'

.

column datatype );

 integer,

 Item_name char(15),

 Type char(15),

 DOS date,

 Price decimal,

 Discount integer

);

create table FURNITURE

(

 No integer,

 Item_name char(15),

 Type char(15),

 DOS date,

 Price decimal,

 Discount integer

);

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


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

 Two Table General Syntax and Example:

SELECT  T2C,  T1C,  FROM  TABLE2  T2,  TABLE1 T1 WHERE T2..PKEY=T1..FKEY  CONDITION

EXAMPLE:
SELECT NAME, DEPARTMENT FROM EMPLOYEE E, DEPT D WHERE E.DCODE=D.DCODE AMD ENO<1003;      (OD. 2015)

SELECT  PNAME, SNAME FROM PRODUCTS P , SUPPLIERS S WHERE P.SUPCODE=S.SUPCODE AND QTY>100;  (OD 2013