Question 1) What is Normalization? Describe the condition under which the relation requires to be normalized to 3 NF fro3 2 NF with the help of an example?
Question 2) Compare primary, secondary and clustering indexes. Which of these indexes are dense and which are not?
Question 3) What is difference between B tree and B+ tree? Why B+ tree is the better tree structure than B tree for implementation of an indexed sequential file.
Question 4) Consider following employee database schema:
Employee ( ESSN ,ENAME , DOB , DEPT-NO , SALARY)
Dependent (ESSN, DEPENDENT_NAME, RELATION, DOB)
Department (DEPT_NO, DEPT_NAME, MANAGER)
Perform the following queries using SQL
(a) Determine details of dependent for employee having name ABC.
(b) Determine name of manager of the department in which employee whose ESSN code is 1234
(c) Determine name of all employees whose age is less than 18 years.
(d) Determine DOB of the son of employee having employee code ESSN 5078
Question 5) Explain benefits of data replication in DDBBMS? What typical units of data are replicated in a process of data replication?