• Attempt any five questions.
• All questions carry equal marks.
What is a data model? Explain object-oriented and relational data models with suitable examples.
Define database languages in DBMS. Describe DDL, DML, DCL and TCL along with their commands and examples.
What is ER Diagram? Explain different Components of an ER Diagram with their Notation. Draw an ER Diagram for Employee Project Management System.
Explain Relational Algebra in DBMS. Illustrate Theta Join, Equi Join and Natural Join with suitable examples.
What are keys in the relational model? Explain super key, candidate key, primary key, alternate key and foreign key with suitable examples.
Describe integrity constraints in DBMS. Explain domain integrity, entity integrity and referential integrity with suitable examples.
Explain indexing in relational databases. Discuss different types of indexes and their role in improving query performance.
Consider the relation R (A,B,C,D,E) with the following functional dependencies : AB, BC, AD, DE Answer the following: (i) Find all candidate keys of R. (ii) Decompose the relation into 3NF.
Consider the relation : STUDENT (Roll No, Name, Dept, Course, Instructor) with Functional Dependencies: RollNo Name, Dept Course Instructor Answer the following: (i) Identify whether the relation is in 1NF, 2NF or 3NF. (ii) Normalize the relation up to 3NF.
Discuss recovery from transaction failures. Explain log-based recovery techniques and the role of checkpoints in recovery.
What is deadlock in DBMS? Explain deadlock detection, prevention and recovery techniques.
Explain Concurrency Control in DBMS. Discuss locking techniques including shared locks, exclusive locks and two-phase locking protocol.
Explain the concept of a transaction system in DBMS. Discuss transaction states and ACID properties of a transaction.
What do you understand by database security? Explain authentication and authorization mechanisms in DBMS by explaining how do they ensure database security.
Explain cursor management in PL/SQL. Discuss explicit cursors, nested cursors and parameterized cursors with examples.
