ormalization Exercise HEALTH HISTORY REPORT PET ID 246 PET NAME ROVER PET TYPE PET AGE OWNER DOG VISIT DATE JAN 13/2002 MAR 27/2002 APR 02/2002 12 SAM COOK 01 - RABIES VACCINATION 10- EXAMINE and TREAT WOUND 05 - HEART WORM TEST TERRY KIM JAN 21/2002 MAR 10/2002 298 SPOT DOG 08 TETANUS VACCINATION 05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001 JAN 13/2002 01 - RABIES VACCINATION 01-RABIES VACCINATION 519 TWEEDY BIRD TERRY KIM APR 30/2002 APR 30/2002 20 - ANNUAL CHECK UP 12 - EYE WASH UNF Pet [ pet id, pet name, pet type, pet age, owner, visitdate, procedure_no, procedure name)] 1NF: Pet I pet id, pet name, pet type, pet age, owner ] Pet Visit [ pet id, visitdate, procedure no, procedure_name ] note: a procedure may occur on multiple dates, therefore visitdate is included as part of the key 2NF Pet I pet id, pet name, pet type, pet age, owner ] Pet Visit [ pet id, visitdate, procedure no] Procedure [ procedure no, procedure_name ] 3NF: same as 2NF Create an ER diagram using Workbench for the following schema: See Solution for Normalization Exercise1 You can use Workbench. Show, tables, PK, relationships, foreign keys. In addition, create the database and Add three rows of data Create three SQL statements that can be run against the database