QuestionQuestion

Transcribed TextTranscribed Text

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

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

1. Table 1
Startup column : PetName, PetType, PetBreed, PetDOB, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail, Service, Date Charge

Pet (PetID, OwnerID, PetName, PetType, PetBreed, PetDOB)
Owner (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail )
Service (ServiceID, OwnerID, PetID, ServiceName, Date Charge)...
$42.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats