Normalization

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 🙂