Normalization
1. Below is one report from some pet clinic:
HEALTH HISTORY REPORT
PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROC.No, PROC DESC.
246 ROVER DOG 12 SAM COOK JAN 13/2002 01 – RABIES VACCINATION
MAR 27/2002 10 – EXAMINE and TREAT WOUND
APR 02/2002 05 – HEART WORM TEST
298 ROVER DOG 2 TERRY KIM JAN 21/2002 08 – TETANUS VACCINATION
MAR 10/2002 05 – HEART WORM TEST
341 MORRIS CAT 4 SAM COOK JAN 23/2001 01 – RABIES VACCINATION
JAN 13/2002 01 – RABIES VACCINATION
5 19 TWEEDY BIRD 2 TERRY KIM APR 30/2002 20 – ANNUAL CHECK UP
APR 30/2002 12 – EYE WASH
U n -normalized form (UNF) : (PET_ID, PET_NAME, PET_TYPE, PET-AGE, OWNER, (VISIT_DATE,
PROC_NO, PROC_DESC)* )
Normalize the design so that the resultin g relational schemas are in 3NF. Only list the final relational
schemas , no process necessary.
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂