Question Papers of IGNOU MCA-OLD CS06


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

F#FNAMECCODE
: [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 >>