4. Below is a table of a Construction Company with the Employees, Department, Projects & Budget Information. Convert the

[answerhappygod]

4 Below Is A Table Of A Construction Company With The Employees Department Projects Budget Information Convert The 1 (78.72 KiB) Viewed 42 times

4. Below is a table of a Construction Company with the Employees, Department, Projects & Budget Information. Convert the table to normalized form & answer the questions (25 Marks) Dep ID Dep Name Emp ID Functional Dependencies Emp ID and Proj ID -> Budget time Proj ID -> Proj Name Emp ID-> Emp Name Emp ID-> Dept ID Emp_Name Proj ID Proj Name Budget Time (a) What form is the table already in? (b) Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). (c) Identify the primary and foreign keys in your 3NF relations.