16

0520MCA 102072102

employees. You can make other additional assumptions that make sense in the

real world.
OR
Identify the additional operations of relational algebra with suitable example.
Module II
Discuss the anomalies at different levels of normalization with example.
OR
Describe the informal design guidelines for relational databases.
Module III

Explain why concurrency control mechanism needed (൩ transaction
management.

OR
Define lock granularity and explain different levels of locking methods for
concurrency control.

Module IV
Elaborate on different file organization methods in data storage.

OR
Explain the structure and search operation of a B+ Tree with an example.

Module V
Explain about non-relational distributed databases.

OR
Discuss about MongoDB sharding and replication.

+ داد

Page 2 of 2

(6)

(6)

(6)

(6)

(6)

(6)

(6)

(6)

(6)