Database Normalization Problems

Normalization Assignment Take the following “tables” and convert them into a normalized form with primary and foreign keys. Format your answers like the following: TABLE_NAME (PrimaryKey, ForiegnKey, other_element1, other_element2…) 1. 2. PetName PetType PetBreed PetDOB OwnerLastName OwnerFirstName OwnerPhone OwnerEmail Service Date Charge King Dog Std. Poodle 27-Feb-12 Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com Ear Infection 17-Aug-14 $ 65.00 Teddy Cat Cashmier 1-Feb-11 James Richard 201-735-9812 Richard.James@somewhere.com Nail Clip 5-Sep-14 $ 27.50 Filo Dog Std. Poodle 17-Jul-13 Downs Marsha 201-823-5467 Marsha.Downs@somewhere.com A J Dog Collie Mix 5-May-13 Frier Liz 201-823-6578 Liz.Frier@somewhere.com One year shots 5-May-14 $ 42.50 Cedro Cat Unknown 6-Jun-10 James Richard 201-735-9812 Richard.James@somewhere.com Nail Clip 5-Sep-14 $ 27.50 Woolley Cat Unknown ??? James Richard 201-735-9812 Richard.James@somewhere.com Skin Infection 3-Oct-14 $ 35.00 Buster Dog Border Collie 11-Dec-09 Trent Miles 201-634-7865 Miles.Trent@somewhere.com Laceration Repair 5-Oct-14 $ 127.00 Jedah Cat Abyssinian 1-Jul-06 Evans Hilary 210-634-2345 Hilary.Evans@somewhere.com Booster Shots 4-Nov-14 $ 111.00 ProjectName OwnerContact Phone Category Quantity ItemDescription UnitPrice ExtendedPrice Supplier Discount Highland House Elizabeth Barnaby 555-444-8899 Electrical 1 200 Amp Panel $170.00 $170.00 NW Electric 25.00% Highland House Elizabeth Barnaby 555-444-8899 Electrical 3 50 Watt Breaker $60.00 $180.00 NW Electric 25.00% Highland House Elizabeth Barnaby 555-444-8899 Electrical 7 20 Watt Breaker $35.00 $245.00 NW Electric 25.00% Highland House Elizabeth Barnaby 555-444-8899 Electrical 15 15 Watt Breaker $35.00 $525.00 NW Electric 25.00% Highland House Elizabeth Barnaby 555-444-8899 Electrical 200 12 ga, 3 Wire, per foot $1.50 $300.00 EB Supplies 15.00% Highland House Elizabeth Barnaby 555-444-8899 Electrical 300 12 ga, 3 Wire, per foot $1.25 $375.00 EB Supplies 15.00% Baker Remodel John Stanley 555-787-8392 Exterior 35 Siding, 4x8 feet $22.50 $787.50 Contractor, Inc. 35.00% Highland House Elizabeth Barnaby 555-444-8899 Electrical 10 15 Watt Breaker $35.00 $350.00 EB Supplies 15.00% Baker Remodel John Stanley 555-787-8392 Exterior 28 1x4 - 8 feet $4.75 $133.00 Contractor, Inc. 35.00% Baker Remodel John Stanley 555-787-8392 Exterior 100 Cedar Shingles, bundle $65.00 $6,500.00 Contractor, Inc. 35.00% Highland House Elizabeth Barnaby 555-444-8899 Interior 15 Door $275.00 $4,125.00 Interior, Inc. 15.00% Highland House Elizabeth Barnaby 555-444-8899 Interior 15 Door Hinge Set $29.95 $449.25 Interior, Inc. 15.00% Highland House Elizabeth Barnaby 555-444-8899 Interior 15 Door Handle Set $52.50 $787.50 Interior, Inc. 15.00% Hew Remodel Ralph Hew 555-298-4244 Electrical 1 200 Amp Panel $170.00 $170.00 NW Electric 25.00% Hew Remodel Ralph Hew 555-298-4244 Electrical 2 50 Watt Breaker $60.00 $120.00 NW Electric 25.00% Hew Remodel Ralph Hew 555-298-4244 Electrical 5 20 Watt Breaker $35.00 $175.00 NW Electric 25.00% Hew Remodel Ralph Hew 555-298-4244 Electrical 20 15 Watt Breaker $35.00 $700.00 NW Electric 25.00% Hew Remodel Ralph Hew 555-298-4244 Electrical 150 12 ga, 3 Wire, per foot $1.50 $225.00 NW Electric 25.00% Hew Remodel Ralph Hew 555-298-4244 Electrical 300 14 ga, 3 Wire, per foot $1.25 $375.00 NW Electric 25.00% 3. CustomerLastName CustomerFirstName Phone CourseDate AmountPaid Course Fee Johnson Ariel 206-567-1234 10/1/2015 $250.00 Adv Pastels $500.00 Green Robin 425-678-8765 9/15/2015 $350.00 Beg Oils $350.00 Jackson Charles 360-789-3456 10/1/2015 $500.00 Adv Pastels $500.00 Johnson Ariel 206-567-1234 3/15/2015 $350.00 Int Pastels $350.00 Pearson Jeffery 206-567-2345 10/1/2015 $500.00 Adv Pastels $500.00 Sears Miguel 360-789-4567 9/15/2015 $350.00 Beg Oils $350.00 Kyle Leah 425-678-7654 11/15/2015 $250.00 Adv Pastels $500.00 Myers Lynda 360-789-5678 10/15/2015 $0.00 Beg Oils $350.00