PET ID PET NAME PET$\_$TYPE$\_$ID PET TYPE PET AGE ID$/$OWNER VISIT DATE PROC ID $/$ Procedure

$246$ ROVER $1001$ DOG $121-$SAM COOK JAN $13/200201-$ RABIES VACCINATION

MAR $27/200210-$ EXAMINE and TREAT WOUND

APR $02/200205-$ HEART WORM TEST

$298$ SPOT $1001$ DOG $25-$TERRY KIM JAN $21/200208-$ TETANUS VACCINATION

MAR $10/200205-$ HEART WORM TEST

$341$ MORRIS $2001$ CAT $47-$ SAM COOK JAN $23/200101-$ RABIES VACCINATION

JAN $13/200201-$ RABIES VACCINATION

$519$ TWEEDY $4001$ BIRD $29-$TERRY KIM APR $30/200220-$ ANNUAL CHECK UP

APR $30/200212-$ 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.

Normalize to $3$NF$.$

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.

give me ER$-$Diagram in $3$NF: