CS06: Database Management System
Year: 1998 TEE: December Time 3 Full Marks 75
Note: There are six questions in this paper. Question number 1 is compulsory Answer any three from the rest.
Q.1(a): Consider the following 3 tables S, P and SP in which S# is supplier code, P# is product code and QTY is quantity and others carry their respective meanings.
S Table
| S# | SNAME | SCITY | TURN
| Q.1(b): Define 2NF and 3NF. Produce 3NF table structures from the table below.
CINEMAS
: [10]
Q.2: Explain the following terms:
(i) Inverted list
(ii) Referential integrity
(iii) Foreign Key
(iv) Candidate Key
(v) B-Tree: [15]
Q.3(a): What is normalisation? What are the properties of normalisation? Explain.: [7]
home || Next >> |
|