Data NormalizationVeterinarian Report

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.

Patlant Address1 Address2 Date Patient Namo Animal Codo Charge Owner Owner Last Number Name Mage1 Magee Owner First Name Elaine Animal Description Service Code Number 417 Service Description Beau 23 E St Houston, 1/4/0% GR TX 238 148 Rables shot 15.00 Rea DID 25.00 417 Beau Maggi Mago0 Elaine23 Elm St Houston, 174730% GR TX Golden Retriever Golon Retriever Golden Retriever Dalmatlan 417 Beau Maga Magee Elaine 1/4/06 GR 337 Bloodwork 20.00 Luigi Coca Cociolo Tony 1/9/6 238 Rables Shot 16.00 23 Elm St Houston, TX 8 Oak St Houston, TX 8 Oak St Houston, TX 8 Oak St Houston, Luigi Coc Cociolo Tony 1/9/% Dalmatian 500 9100 Luigi Coca Cociolo Tony 1/24/ ON Dalmatian 500 Kenne Medium Kennel Medium Flea DIP Luigi Coc Cociolo Tony 8 Oak St Dalmatian 148 25.00 Houston, TX Sprockley. 2216 Astro Jetsi Jatson Georgo 3 All Rd MX Canine Mixed 368 Ear Cleaning 17.00