• Attempt any five questions.
• All questions carry equal marks.
What is Schema? Explain Overall Database Structure with suitable example.
Explain about Various Data Models.
Explain the following with examples.
i) DDL
ii) Embedded SQL
Explain about Outer join Operation in Relational algebra.
What is Relational Model? Distinguish between Super Key, Candidate Key, Primary Key for a relation with examples.
Explain about Domain relational calculus with examples.
Discuss the importance of integrity and referential integrity constraints.
What are the Conditions required for a relation to be in 3NF explain with examples?
Explain fundamental Operations in relational algebra with examples.
Discuss in detail about timestamp based Concurrency Control techniques.
What is locking protocol? Describe the Strict Two-Phase locking Protocol.
Discuss about Comparative study of OODBMS Vs DBMS.
Explain Hierarchical queries and inline queries with suitable examples.
What is a Cursor? Explain nested and Parameterized cursors?
Write short notes on any two:
DML
Multimedia
Triggers
Stored Procedures
