Question: Using ERDPlus, create an ERD that can be implemented for a medical clinic, using the following business rules: 1 . A patient can make many
Using ERDPlus, create an ERD that can be implemented for a medical clinic, using
the following business rules:
A patient can make many appointments with one or more doctors in the clinic,
and a doctor can accept appointments with many patients. However, each
appointment is made with only one doctor and one patient.
If kept, an appointment yields a visit with the doctor specified in the appointment. Some appointments get cancelled and do not yield visits. Some visits
are walkin and are not linked to an appointment.
For each visit, there could be one or many diagnoses and corresponding treatments for those diagnoses.
Each visit creates a bill. Each bill is linked to just one visit.
Each bill must be paid. However, a bill may be paid in many installments,
and a payment may cover more than one bill.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
