Analyze and normalize the below relation to achieve 3rd Normal Form compliance. The relay Michael uses the below excel sheet to track and maintain history of his work orders and jobs. Identify opportunities for Norma  explain  your normalization steps.

 

Transcribed Image Text:

Job Date 1/1/2023 2/2/2023 2/25/2023 Customer Address 123 Main St. Brampton 4221 HappyDays St. North York Ahmed Malik 5321 CarlingCare Dr. Mississauga Kate Myles Customer dame Customer Phone No Work Type Mike Smith 647 123 1212 416 123 2345 905 321 9721 Plumping Repairs. Electrical Painting Material Mater (Vanity faucet, tapes, pipes) (100, (Light Fixure, Wires, Outlets) (150, (Paint, consumables) (300, Job Date 1/1/2023 2/2/2023 2/25/2023 Customer Address 123 Main St. Brampton 4221 HappyDays St. North York Ahmed Malik 5321 CarlingCare Dr. Mississauga Kate Myles Customer dame Customer Phone No Work Type Mike Smith 647 123 1212 416 123 2345 905 321 9721 Plumping Repairs. Electrical Painting Material Mater (Vanity faucet, tapes, pipes) (100, (Light Fixure, Wires, Outlets) (150, (Paint, consumables) (300,

Answer rating: 100% (QA)

The following table is not in 3rd Normal Form because it has a transitive dependency Job Date Customer Address Customer Name Customer Phone Work Type Material 112023 123 Main St Brampton Mike Smith 64... View the full answer