Database design

you must use visio

Week 2 Labs
Note:
Assignment will be checked thru both Turnitin and AI
In this Lab, you will create an entity relationship diagram (ERD) for a portion of a
database that a veterinary clinic might use to keep track of clients, veterinarians,
patients, appointments, and procedures.
The major entities involved in this database design are listed below.
•
•
•
•
•
Clients (humans)
Patients (animals)
Veterinarians
Appointments
Procedures (veterinary procedures, such as tests or treatments performed
during appointments)
Below are the business rules that apply to these entities.
•
•
•
•
Each Client owns zero or many Patients; each Patient is owned by
exactly one Client.
Each Patient can have zero or many Appointments; each Appointment is
for exactly one Patient.
Each Appointment is with exactly one Veterinarian; each Veterinarian
can have zero or many Appointments.
Each Procedure can be performed during zero or many Appointments;
each Appointment can include the performance of zero or many
Procedures.