HEALTH HISTORY REPORT PET ID 246 PET NAME ROVER PET TYPE ID PET TYPE PETAGE IDIOWNER VISIT DATE 1001 cedure DOG 12 1 -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 1001 DOG 5 -TERRY KIM JAN 21/2002 MAR 10/2002 08 TETANUS VACCINATION 05 HEART WORM TEST 341 MORRIS 2001 CAT 4 7 - SAM COOK JAN 23/2001 JAN 13/2002 01 - RABIES VACCINATION 01 - RABIES VACCINATION 519 TWEEDY 4001 BIRD 9-TERRY KIM APR 30/2002 APR 30/2002 20 - ANNUAL CHECK UP 12 - EYE WASH Description: A pet is identified by the Pet ID. A Pet can be one Pet Type Only but there are from zero to many Pets of a particular Pet Type. A Pet has one and only one owner, but an owner has from one to many pets. Add an Owner ID to the Owner Table. A pet has from one to many isits (ADD A VISIT ID to a Visit Table that Includes the Visit Date and whatever foreign keys are necessary). During a isit, there are one to many procedures and each procedure is represented in one to many visits. The procedure table will need to have a procedure ID and the Procedure description. Normalize to 3NF. Hint: use an iterative process - identify the dependencies and work with the ERD to eliminate many to many relationships and transitive dependencies. Make sure every relationship is connected with a foreign key. ERD in 3NF