Question: ProdCo Show Actor E. Estrada CHiPS Rosner L Wilcox CHiPS Rosner M. Dorn CHiPS Rosner R. Oakes CHiPS Rosner G. Peppard J Cannell A Team

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