Header Ads

PRINCIPLES OF DATABASE DESIGN S4 KTU QUESTION PAPERS II



PART A

1. Define

a. DBMS

b. Weak entity

2. What are the responsibilities of database administrator?

PART B

3. Explain Entity Integrity and Referential Integrity with suitable examples.

4. Explain the different types of keys with suitable examples. 

5. Explain the different constraints on binary relationships.

PART C

6. Explain three schema architecture. Differentiate between logical data independence and physical data independence.

7. Discuss ER to relational schema mapping with examples.

8. What are the different types of attributes? Draw ER diagram for a school database.


Powered by Blogger.