Advanced Database Management System 2073

Attempt all Questions.

1. Discuss different constraints of specialization and generalization.

2. Draw an ER diagram for a hospital with a set of patients and a set of doctors. Associate with each patient a log of various tests and examinations conducted.

3. Define encapsulation? How is it used to create abstract data types?

4. What is versioning? Why is it important? What is the difference between versions and configurations?

5. What is object relational database? Discuss object relational features of SQL.

6. Define active database. Discuss some applications of active databases.

7. What is the difference between valid time, transaction time, and bitemporal relations?

8. What is data mining? Discuss data mining as a part of knowledge discovery process.

9. What is data warehouse? Discuss the typical functionality of data warehouse.

10. What is mobile database? Discuss the characteristics of mobile environments.