- Please Answer 4a 4b And 4c Will Upvote 1 (99.12 KiB) Viewed 14 times
PLEASE ANSWER 4a, 4b,and 4c WILL UPVOTE
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
PLEASE ANSWER 4a, 4b,and 4c WILL UPVOTE
PLEASE ANSWER 4a, 4b,and 4c WILL UPVOTE
4. Below is a table of a Construction Company with the Employees, Department, Projects & Budget Information. Convert the table to normalized form & answer the following 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.
4. Below is a table of a Construction Company with the Employees, Department, Projects & Budget Information. Convert the table to normalized form & answer the following 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.