CS-06 Data Base Management system Dec-2001
Question Paper of CS-06 Data Base Management system Dec-2001
Q.1(a). Design a Relational database to the E- R diagram given below:
Image No. 1
Tabular representation of the Relational Database for the above E-R Diagram
Entities and its Attributes :
(b) Explain the following general integrity rules of Relational Mode:
(i) Entity Integrity
(ii) Referential Integrity
© For the relations P and Q, perform the following operation:
(i)Find the projection of Q on the attributes (B,C)
(ii) Find the natural join of P and Q on the common attributes.
(d)Write short notes on:
(i) Object oriented databases
(ii) Specialization
(iii) Generalization
(iv) Data independence
(v) Query processor