Using the view for a veterinarian practice designated problem 4, normalize the data into the required third normal form tables. Present the record structure for each normalized table and indicate the primary keys and embedded foreign keys. Note that an owner may own more than one animal.

Transcribed Image Text:

Patient ID Number 417 417 417 632 632 632 632 168 ...……... Patient Owner Owner Owner Address1 Address2 Date Animal Code Name Beau Beau Beau Luigi Luigi Luigi Luigi Astro ID Number Magel Magel Magel Cocil Cocil Cocil Cocil Jetsl n Last Name Magee Magee Magee Cociolo Tony Cociolo Tony Tony Cociolo First Name Elaine 23 Elm St Houston, 1/4/xx TX 23 Elm St Houston, 1/4/xx Elaine V Elaine Cociolo Tony Jetson George 23 Elm St 8 Oak St 8 Oak St 8 Oak St PROBLEM 4 8 Oak St 3 Air Rd 1/4/xx TX Houston, TX Houston, TX Houston, TX Houston, 1/24/xx DN TX Houston, 2/1/xx DN TX 1/9/xx GR 1/9/xx GR GR DN DN Sprockley, 2/2/xx MX TX Animal Service Description. Code Golden Retriever Golden Retriever Golden Retriever Dalmatian 238 238 Dalmatian 148 Dalmatian 500 Canine Mixed 337 Dalmatian 500 148 368 Service Charge Description Rabies Shot 15.00 Flea Dip Bloodwork Kennel- Medium Rabies Shot 15.00 Kennel- Medium Flea Dip 25.00 Ear Cleaning 20.00 9.00 9.00 25.00 17.00