16.

27.
15.
29.

21.

' 0 80867

Part C
Answer any five questions.
Kach question carries 6 marks.
What are the three levels of data abstraction ?
Kxplain different categories of data models.
Explain different control structures in SQL.

Explain two phase locking.
Kxplain how to create, modify, and delete triggers.
Write a comparison on relational calculus and domain calculus.

Wnite a comparison on file system and DBMS.
Explain how to create, modify, and delete triggers.
(5 x § = 26 marks)

Part D
Answer any three questions.

Each question carries 10 marks.

Explain ER diagram with example.
Write a short note on aggregation, generalization and specialization.

Explain different types of keys with example.
Explain three schema architecture and data independence.

What is Normalization ? Explain different normal forms.
(3 x 10 = 80 marks)