Adhering to the standards defined in class, develop a conceptual data model for a pet health history database. Using the repo

Adhering to the standards defined in class, develop a conceptual data model for a pet health history database. Using the report shown below, create 1NF, 2NF and 3NF dependency diagrams and resulting 3NF ERD model using Lucid Chart for the vet clinic based on the review the following Veterinary Health History Report show below: HEALTH HISTORY REPORT PET ID PET NAME PET TYPE PET AGE VISIT DATE JAN 13/2002 01 RABIES VACCINATION MAR 27/2002 10 EXAMINE and TREAT WOUND OWNER PROCEDURE DOG 246 ROVER 12 SAM COOK APR 02/2002 05- HEART WORM TEST JAN 21/2002 MAR 10/2002 05 – HEART WORM TEST 298 SPOT DOG 2 TERRY KIM 08 TETANUS VACCINATION JAN 23/2001 JAN 13/2002 341 MORRIS CAT SAM COOK 01 – RABIES VACCINATION 01 RABIES VACCINATION 519 TWEEDY TERRY KIM APR 30/2002 APR 30/2002 BIRD 2 20 ANNUAL CHECK UP 12- EYE WASH Note: Although not a part of the final ERD, your 1NF, 2NF and 3NF dependency diagrams should be included in your submitted work for full credit.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *