Madurai Kamraj University (MKU) 2006 M.C.A -IV RELATIONAL DATABASE MANAGEMENT - Question Paper

Time: 3 hours maximum: 100marks
PART A ans all ques. (8x5=40 marks)

1. (a) List the advantages of RDBMS. Or (b). What is meant by entity set? discuss with an
example

2. (a) Write short notes on tuple relational calculus. Or (b) what is an index? How it is
used in RDBMS?

3. (a) Compare data retrieval in network model and hierarchical model. Or (b) discuss the
concept based on relational database design with respect to repetition of info.

4. (a) What is view? Whether multiple view updations are applicable in RDBMS? Or (b).
discuss about aggregate operators in detail.

5. (a). discuss the anomalies in relation database design. Or (b) discuss the BCNF with
examples.

6. (a) Write short notes on snapshots. Or (b). What is RQBE? What is its role in database?

7. (a) discuss the theory of multi-valued dependencies. Or (b) discuss in detail about lossless-
join decomposition.

8. (a). What is distributed database? Where it is in high demand? Or (b) Write down the
method of providing security to the relational database.

PART B ans ALL ques. (5x12=60 marks)

9. (a) discuss about various keys available in RDBMS and write down the significance
every key with an example. Or (b) discuss the various access methods and storage
structures in RDBMS.

10. (a) explain the data modeling concepts in detail. Or (b). What is correlated sub query?
Illustrate with an example of a correlated sub query projection and union operation as
relational algebra expressions.

11. (a). discuss with example, the various operations in relational algebra. Or (b) discuss
the subsequent terms: I) Full functional dependency. II) Temporal Relational model. III)
Repetition of info

12. (a) discuss in detail, the different stages involved in compiling a query with a neat
diagram. Or (b) define the security problems and integrity factors regarding database
systems.

13. (a) discuss how will you normalize the provided table to the 3rd normal form, by
assuming your own table. Or (b). explain in detail about database administration?

Earning:   Approval pending.