1.a. Define DBA.Discuss role of DBA.

1.b. Explain components of ER Models

1.c. Explain ACID properties of transaction

1.d. Explain Database Languages.

2.a. Define deadlock.Explain Deadlock detection,prevention and recovery.

2.b. List 5 significant differences between file processing system and database management systen

3.a. Explain overall architecture of DBMS in detail.

3.b. Construct ER diagram and convert into relational model for company.Which has several employees working on different types of projects.Several employees are working on one department .Every employee has manager.Several employees are supervised by one employee.

4.a. Explain the concept of serializability with its types.

4.b. Explain following relational algebra operations with suitable example

(a)project (b)select

(c)union (d)Cartesian product

5.a. Employee(eid,ename,address,city)

Works(eid,cid,city)

Company(cid,cname,city)

1)modify database so that john now lives in mumbai.

2)find employee who live in same city as the company for which they work.

3)give all employees of 'AZ Corporation ' where there is increase in salary by 15%.

4)Find the names of all employees, company name and city of residence such that employee name begins with'I'

5)delete all tuples in works relation for employees of small bank corporation.

5.b. Define Normalization.Discuss 1NF,2NF,3NF in detail

6.a. Log Based Recovery.

6.b. Constraints in SQL.

6.c. Specialization and Generalization