Explaining normalization - b tree - clustering indexes


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?

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Explaining normalization - b tree - clustering indexes
Reference No:- TGS02342

Expected delivery within 24 Hours