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

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

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