1) Explain the system structure of the database system in detail.
2)(a) Write down the functions of a DBA.
(b) Demonstrate the issues to be considered while developing the ER-diagram.
3)(a) Let the relational database:
employee (emp name, street, city)
works (emp name, company name, salary)
company (company name, city)
manages (emp name, manager name)
Write down the expression in relational algebra for each request:
(i) Determine the names of all employees who work for First Bank Corporation.
(ii) Determine the names, street addresses, and cities of residence of all employees who work for First Bank Corporation and earn more than 200000 per annum.
(iii) Determine the names of all employees who earn more than every employees of Small Bank Corporation.
(iv) Determine the names of all employees in this database who live in the same city as the company for which they work.
(b) What do you mean by nested queries?
4)(a) Write down the relational algebra operations supported in SQL? Write down the SQL statement for each operation.
(b) Describe in detail about Query languages.
5) Explain on two-phase locking protocol and timestamp – based protocol.
6)(a) Write down the difference between primary index and secondary index.
(b) Describe in detail about Hash functions.
7)(a) What is meant by normalization? Describe 1NF, 2NF, 3NF and BCNF with suitable examples.
(b) Describe the role of FD in the process of normalization.
8)(a) Write down the features of object oriented database.
(b) Compare OODBMS with ORDBMS.
9) Describe the different approaches in which data can be fragmented in a distributed database. Describe with suiatble example.