Question: ProdCo Show CHiPS CHiPS CHiPS CHiPS A Team A Team ProdAddress 7 Mary 3 7 Mary 3 7 Mary 3 7 Mary 3 123 Main

ProdCo Show CHiPS CHiPS CHiPS CHiPS A Team A Team ProdAddress 7 Mary 3 7 Mary 3 7 Mary 3 7 Mary 3 123 Main St 123 Main St Seasons Actor E. Estrada L Wilcox M. Dorn R. Oakes G. Peppard Rosner (1, 2, 3,4, 5,6 Rosner Rosner (2, 3, 4, 5) Rosner (3, 4, 5) J Cannell J Cannell FD's {Show, Actor) -> Seasons {Show) -> ProdCo ProdCo) -> ProdAddress 1. Identify the violations of 1NF if any 2. Identify the violations of 2NF if any 3. Identify the violations of 3NF if any 4. Draw a dependency Diagram 5. Decompose into 1NF 6. Decompose into 2NF and 3NF. ProdCo Show CHiPS CHiPS CHiPS CHiPS A Team A Team ProdAddress 7 Mary 3 7 Mary 3 7 Mary 3 7 Mary 3 123 Main St 123 Main St Seasons Actor E. Estrada L Wilcox M. Dorn R. Oakes G. Peppard Rosner (1, 2, 3,4, 5,6 Rosner Rosner (2, 3, 4, 5) Rosner (3, 4, 5) J Cannell J Cannell FD's {Show, Actor) -> Seasons {Show) -> ProdCo ProdCo) -> ProdAddress 1. Identify the violations of 1NF if any 2. Identify the violations of 2NF if any 3. Identify the violations of 3NF if any 4. Draw a dependency Diagram 5. Decompose into 1NF 6. Decompose into 2NF and 3NF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
