Question: Given the following report sample create a database for Veterinary Clinic. Normalize it to the 3NF, showing all the steps necessary. HEALTH HISTORY REPORT PET

Given the following report sample create a database for Veterinary Clinic. Normalize it to the 3NF, showing all the steps necessary. HEALTH HISTORY REPORT PET ID PET NAME PET TYPE PET AGE OWNERVISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002 MAR 27/2002 APR 02/2002 01 - RABIES VACCINATION 10 - EXAMINE and TREAT WOUND 05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002 MAR 10/2002 08 - TETANUS VACCINATION 05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001 JAN 13/2002 01 - RABIES VACCINATION 01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002 APR 30/2002 20 - ANNUAL CHECK UP 12 - EYE WASH Due: Deliverables: 1) This cover sheet 2) Completed assignment on the separate paper(stapled to this sheet)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
