Question

Data Normalization—Veterinarian 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

Answer 1

ANSWER:

As per the given Question

The following are the tables of data normalization of veterinarian practice: Owner Table: Owner ID Number (PK) Owner Last Name Owner First Name Address 1 Address 2 Patient Table: Patent iD (PK) Patent Name owner ID Number () | Animal Code (76) Animal Table: Animal Code (PK) Animal Description Service/Patient Link Table: Patient ID (PK) Service Code (PK) (FK) Date Service Table: Service Code (PK) Service Description Service Charge

Thank you for Question.......kindly rate.......it helps me a lot