Define distributed database. What are the benefits of using distributed databases over centralized database? Explain availability, reliability, and scalability features of distributed databases. [10]
2.
Why fragmentation is carried out? Difference between horizontal and vertical fragmentation. [5]
3.
Why NOSQL system is essential? What are the different characteristics of this system? [5]
4.
What is spatial database? Explain the concept of trigger with an example. [5]
5.
Write short notes on a. CAP Theorem b. Deductive database [5]
Enhanced Entity Relationship Model and Relational Model
1.
Design an EER model for library management system having generalization and specialization hierarchies. The EER model should have disjoint and overlapping constraints with at least one of the entities having total participation. Use your own assumption for other concepts. Now convert the EER diagram into its equivalent relational model. [10]
2.
What is aggregation? Explain with example. [5]
Object and Object Relational Databases
1.
What are different concepts and features of object oriented databases? What is object relational model? [10]
2.
Define ODMG Object model? What is Object Query Language(OQL)? [5]
Query Processing and Optimization
1.
Why indexing is important to store data in database? What's multilevel index? [5]
2.
What is query processing? Differentiate query processing with query optimization. [5]
3.
Why query optimization is necessary? Illustrate on the choices of query execution plans. [5]