Using Draw.IO

PLEASE USE DRAW.IO it is easier for me to read and understand!!! PLEASE MAKE THE LINES CLEAR

IF YOU DECIDE TO DRAW IT PLEASE DRAW IT AS YOU WOULD IN DRAW.IO

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 too many procedures and each procedure is represented in one too 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 too many relationships and transitive dependencies. Make sure every relationship is connected with a foreign key.

ERD in 3NF:

Review the information linked below this assignment on "Veterinarian Practice" which documents a "Health History Report" that we want to convert into a set of normalized tables.

Use entity-relationship diagramming and normalization to determine the fully normalized implementation of the database.

Create a diagram in Draw.IO

Veterinarian Practice PET ID PET NAME 248 ROVER PET TYPE ID 1001 HEALTH HISTORY REPORT PET TYPE PET AGE DOWNER VISIT DATE DOG 12 1-SAM COOK JAN 13/2002 MAR 27/2002 APR 02/2002 DOG 5 -TERRY KIM JAN 21/2002 MAR 10/2002 CAT 7- SAM COOK JAN 23/2001 JAN 13/2002 PROC ID / Procedure 01- RABIES VACCINATION 10-EXAMINE and TREAT WOUND 05 - HEART WORM TEST 08 - TETANUS VACCINATION 05 - HEART WORM TEST 298 SPOT 1001 2 341 MORRIS 2001 4 01 - RABIES VACCINATION 01 - RABIES VACCINATION 519 4001 BIRD 2 TWEEDY 9-TERRY KIM APR 30/2002 20-ANNUAL CHECK UP APR 30/2002 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 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