1.a. Explain role of DBA?

1.b. List all the functional dependencies satisfied by the relation.

X	Y	Z
X1	Y1	Z1
X1	Y2	Z1
X2	Y2	Z1
X2	Y2	Z1

1.c. What is the difference between unique key and primary key?

1.d. Explain different types of attributes with examples?

2.a. Explain static hashing technique with example?

2.b. Define normalization? Explain 1NF, 2NF and 3NF with examples?

3.a. Consider the following employees database.

Employee (empname, street, city, date_of_joining )
Works (empname, company_name, salary )
Company (company_name, city )
Manages (empname, manager_name )

Write SQL queries for the following statements:

1. Modify the database so that employee "Sachin" now lives in "Mumbai".
2. Find number of employees in each city with date_of_joining as "01-Aug-2017".
3. List the name of companies starting with letter "A".
4. Display empname, manager_name, city of those employees whose date_of_joining is greater then "01-01-2014".

3.b. Explain DBMS architecture.

4.a. Construct a dependency diagram of relation R and normalize it up to the BCNF normal form.

4.b. Explain different types of relational algebra operations.

5.a. Explain cursors and its types with example.

5.b. Draw EER diagram for hospital management system showing constraints on generalisation and specialisation.

6.a. Types of entities.

6.b. Authorisation in SQL.

6.c. Views in SQL

6.d. B-tree.