Create a database for a veterinarian office. The database design needs to confirm to the following requirements:
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a database for a veterinarian office. The database design needs to confirm to the following requirements:
- The database needs to track customers (including contact information and where they live).
- It needs to track pets (including type of animal - dog, cat, etc, who owns the pet).
- It needs to track visits - ie pet visits the veterinarian.
- When a pet visits the veterinarian they could have 0 or more diagnosis. This table will contain values for all possible diagnosis.
- Each diagnosis might have 0 or more treatments. This table will contain records for all possible treatments.
- The database much confirm to 3rd Normal Form.
- You will create an Entity Relationship Diagram (ERD) using Diagrams.net.
Your design does not and should not need to include employees of the office, or appointments.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: