Question: Question 1: a) (Use BCNF procedure (3-steps) to normalize the table given below) Normalize the table R up to BCNF. Clearly show your steps and

Question 1: a) (Use BCNF procedure (3-steps) to normalize the table given below) Normalize the table R up to BCNF. Clearly show your steps and state all Primary and Foreign keys. R (Teamld, TeamName, TeamCoach, Playerld, PlayerName, Year, Score) Functional Dependencies: 1. Teamld TeamName, Team Coach 2. Playerld PlayerName 3. Playerld, Year Teamld, Score wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww w WWWWWWWW b) Normalize the table T up to BCNF. Clearly show your steps and state all Primary and Foreign keys. T(A, B, C, D, E, F, G) Functional Dependencies: 1. A, BD 2. D E, F 3. G C
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
