Download other previous papers from www.ignoubaba.

com

[1] MCS-207 [2] MCS-207

No. of Printed Pages : 4 MCS-207 an example. 5

(c) What is query processing ? List the basic steps

POST GRADUATE DIPLOMA IN in query processing. 5

COMPUTER APPLICATION (d) What are the limitations of Relational
(PGDCA-NEW)
Databases ? Explain the need for object
Term-End Examination
oriented Databases. 5
June 2024
(e) Explain the following basic relational
MCS-207 : DATABASE MANAGEMENT
operations with the help of an appropriate
SYSTEMS
examples for
Time : 3 Hours Maximum Marks : 100
each : 10
Weightage : 70%
(i) SELECTION
Note :– Question No. 1 is compulsory and carries 40 (ii) PROJECTION
marks. Attempt any three questions from (iii) CARTESIAN PRODUCT
Question No. 2 to Question No. 5. (iv) JOIN

1. (a) Compare and contrast the traditional file (f) Design an ER-diagram for the specifications

based system with database approach. 5 to maintain any Hospital. Clearly indicate the
entities, attributes, primary key, constraints,
(b) Explain the desirable properties of
relationships and cardinality. 10
decomposition of a relation with the help of

P.T.O.
 Download other previous papers from www.ignoubaba.com

[3] MCS-207 [4] MCS-207

2. (a) Explain the physical DBMS architecture with Compare and contrast Backward Recovery

the help of a neat diagram. 10 and Forward Recovery. 6

(b) Explain any FOUR (4) commands of DML (c) What is Hash-Join ? Explain the cost

with suitable example for each command. 8 calculation for simple Hash-Join. 7

(c) What is the use of sequential file organization ? 5. Write short notes on the following : 5×4=20

2 (i) Multi-list file organization

3. (a) Explain entity integrity and referential integrity (ii) Second normal form
constraints of a relation with the help of a (iii) Serialisable schedule
suitable example. 6
(iv) Data warehouse
(b) Explain the third normal form and BCNF with
the help of an example. 7
***
(c) Why do we need indexes ? Explain the
following :

(i) Primary index

(ii) Clustering index

(iii) Secondary index 7

4. (a) What is a transaction ? Explain properties of

a transaction with an example. 7

(b) Why do we need database recovery ?

P.T.O.