Page 1 of 1
4. Below is a table of a Construction Company with the Employees, Department, Projects & Budget Information. Convert the
Posted: Tue Jul 12, 2022 8:06 am
by answerhappygod
- 4 Below Is A Table Of A Construction Company With The Employees Department Projects Budget Information Convert The 1 (78.72 KiB) Viewed 43 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.