Reference no: EM131929791

Normalization Problem

a) Consider the Health History Report below for a given hospital and answer the questions that follow.

HEALTH HISTORY REPORT

PET ID PET NAME  PET TYPE  PET AGE  OWNER        VISIT DATE      PROCEDURE

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     SPOT          DOG         2          TERRY KIM    JAN 212002     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

519     TWEEDY      BIRD        2          TERRY KIM       APR 30/2002    20 - ANNUAL CHECK UP

                                                                                       APR 30/2002    12 - EYE WASH

i. Illustrate an example of Insertion, Update and Deletion anomaly from the above report

ii. Represent the above table in UNF

iii. Represent the above table in 1NF

iv. Represent the above table in 2NF

v. Represent the above table in 3NF