Database Management System 2080

Section A
Long Answer Questions
Attempt any TWO questions. [2 × 10 = 20]

1. Define serial, non-serial, and serializable schedules with example. How can you test serializability of a schedule? Explain with an example. [10]

2. What is a transaction? State and explain the states of a transaction with a transition diagram. [2+8]

3. From the relations given below, answer the following questions.
EMPLOYEE (Ssn, Ename, Bdate, Address, Sex, Salary, Super_ssn, Dno)
DEPARTMENT (Dname, Dnumber, Mgr_ssn, Mgr_start_date)
PROJECT (Pname, Pnumber, Plocation, Dnum)
DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship)
DEPT_LOCATIONS (Dnumber, Dlocation)
(a) Retrieve the name and address of all employees who work for the 'Computer' department in SQL.
(b) For each Department, retrieve the department number, the number of employees in the department, and their average salary using SQL.
(c) Retrieve the employees' name and their Dname and Pname ordered by the employee's Dname.
(d) Retrieve the name and salary of all employees who work in department number 5 using Relational Algebra.
(e) Retrieve the name of the manager of each department using Relational Algebra. [5 × 2 = 10]

Section B
Short Answer Questions
Attempt any EIGHT questions. [8 × 5 = 40]

4. What are the advantages of using DBMS? Explain in brief. [5]

5. What are attributes? Explain different types of attributes with example. [5]

6. Define relation, instance, and schema with example. [5]

7. What is normalization? Explain 2NF with examples. [5]

8. What are Shared/Exclusive (Read/Write) Locks? How are they different from binary locks? [5]

9. What is deadlock in DBMS? Explain with example. [5]

10. What is shadow paging? How is it used for database recovery? [5]

11. What is data independence? How does the three-schema architecture ensure logical and physical data independence? [5]

12. What is NoSQL? Explain the characteristics of NoSQL. [2+3]