DATABASE NORMALISATION

TASK Task Please see the table below: Prof Rank Dept Name Emp Num 123 123 104 Emp Name Ghee Ghee Rankin Rankin Rankin Ortega Ortega Ortega Professor Professor Assist prof Assist_prof Assist_prof Assist prof Assist prof Assist prof Dept Code CIS CIS CHEM CHEM CHEM CIS CIS CIS Prof Office KDD7 KDD7 BLF9 BLF9 BLF9 KDD2 KDD2 KDD2 Comp Info Sys Comp Info Sys Chemistry Chemistry Chemistry Comp Info Sys Comp Info Sys Comp Info Sys Adv ID 1215 2312 3102 2782 3311 2134 2789 2002 Adv Name Smith Shaw Daniels Andrews Carter Bentley Franz Jacobs 104 104 118 118 118 Adv DOB 1/1/1990 7/7/1980 8/8/1967 4/4/1947 6/6/1987 3/3/1957 4/4/1977 4/4/1977 IIIII Using above table 1. Draw a dependency diagram for the above table. This diagram should show all the dependencies that exist in this table. (4 marks) 2. What is the normal form of this table? and why? (2 marks) 3. Decompose the above table into a set of 3NF relations. Draw the dependency diagrams for each table in this set, using only the attributes that are provided. (6 marks)