Use entity relationship diagramming and normalization to determine the fully normalized implementation of the database below,

which documents an invoice that we want to convert into a set of normalized tables.

Veterinarian Practice HEALTH HISTORY REPORT PET ID 246 PET NAME ROVER PET_TYPE_ID 1001 PET TYPE PET AGE DIOWNER DOG 12 1-SAM COOK VISIT DATE JAN 13/2002 MAR 27/2002 APR 02/2002 PROC ID / Procedure 01 - RABIES VACCINATION 10- EXAMINE and TREAT WOUND 05 - HEART WORM TEST 298 SPOT 1001 DOG 2 5 -TERRY KIM JAN 21/2002 MAR 10/2002 08 - TETANUS VACCINATION 05 - HEART WORM TEST 341 MORRIS 2001 CAT 7- SAM COOK JAN 23/2001 JAN 13/2002 01 - RABIES VACCINATION 01 - RABIES VACCINATION 519 TWEEDY 4001 BIRD 2 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 visits (ADD A VISIT ID to a Visit Table that Includes the Visit Date and whatever foreign keys are necessary). During a visit, 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