Database design

Description

you must use visio

Don't use plagiarized sources. Get Your Custom Assignment on
Database design
From as Little as $13/Page

Unformatted Attachment Preview

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.

Purchase answer to see full
attachment