• Attempt any five questions.
• All questions carry equal marks.
What is Database Management System (DBMS)? What are the major components of this system? Explain each component with neat sketch.
What are the different Data Models of DBMS? Explain in detail.
Explain strong and weak entities. How weak entity can be converted to a strong entity.
Explain Super key, primary key and candidate key with examples.
What are integrity constraints? Explain various types of integrity constraints with suitable example.
Discuss about Relational algebra operations like Select, Project, Join with examples.
Define join dependency. How is it different to that of Multivalued dependency and Functional dependency? Justify.
Define Normalization. Explain second normal form with the help of an example.
Explain why 4NF is more desirable than BCNF with the help of an example.
What do you mean by transaction processing? Explain ACID properties of transaction in brief.
How concurrency is performed? Explain the protocol that is used to maintain the concurrency concept.
What is time stamping? Explain a mechanism of concurrency control that uses time stamping with the help of an examples.
Explain the advantage of stored procedures with an example.
What is Trigger? Explain in detail with an example.
Nested and Parameterized Cursors
Single level and multilevel indices
Domain Relational Calculus
