HEALTH HISTORY REPORT Pet ID Pet Pet Type Pet Age Owner Visit Procedure Name 246 ROVER DOG 12 JAN 01 RABIES VACCINATION COO 13/2002 10-EXAMINE and 27/2002 TREAT APR 05 HEART WORM TEST 02/2002 298 SPOT DOG TER RY KIM JAN 21/2002 08 TETANUS VACCINATION MAR 10/2002 05- HEART WORM TEST 341 MORRIS CAT SAM COO 23/2001 JAN 01 - RABIES VACCINATION JAN 01 RABIES VACCINATION 13/2002 519 TWEET BIRD TER RY KIM APR 20 ANNUAL CHECK UP 30/2002 APR 30/2002 12 EYE WASH 1. Normalization Exercise: Consider the report on the following page on pet health history. Answer the following questions a. Does this report represent a relation, by the definition discussed in class? b. Create an Entity Relationship Diagram from this data? c. Create a set of relations in third normal form, utilizing a schema diagram, with integrity constraints? HEALTH HISTORY REPORT Pet ID Pet Pet Type Pet Age Owner Visit Procedure Name 246 ROVER DOG 12 JAN 01 RABIES VACCINATION COO 13/2002 10-EXAMINE and 27/2002 TREAT APR 05 HEART WORM TEST 02/2002 298 SPOT DOG TER RY KIM JAN 21/2002 08 TETANUS VACCINATION MAR 10/2002 05- HEART WORM TEST 341 MORRIS CAT SAM COO 23/2001 JAN 01 - RABIES VACCINATION JAN 01 RABIES VACCINATION 13/2002 519 TWEET BIRD TER RY KIM APR 20 ANNUAL CHECK UP 30/2002 APR 30/2002 12 EYE WASH 1. Normalization Exercise: Consider the report on the following page on pet health history. Answer the following questions a. Does this report represent a relation, by the definition discussed in class? b. Create an Entity Relationship Diagram from this data? c. Create a set of relations in third normal form, utilizing a schema diagram, with integrity constraints