Create an entity-relationship model:

 

Instructions:

Using the Crow's Foot notations, create an ERD that for a medical clinic database, using the following business rules:

1. A patient may book appointments with many doctors in the clinic, and a doctor may accept appointments for many patients.
2. An appointment may yield a visit and a visit is associated with one and only appointment. A visit yields a diagnosis and, when appropriate, a treatment.
3. Each patient visit creates a bill.
4. Each bill must be paid. A patient may make many payment transactions to cover the bill total through an installment plan. A payment transaction is associated with one and only one patient.
5. A Payment is processed for one bill at a time by a patient. A bill can be covered though many payment transactions.

Requirements

1. Label  the primary key for each entity
2. Add and label the foreign keys based on the relationship type between entities.
3. Label the relationship between entities.
4. Ensure the following is recorded in the database:
   1. Patient: patient last name, first name, address, email and phone number.
   2. Doctor: Doctor's first name, last name, phone number.
   3. Appointment: Appointment date and time,
   4. Visit: date, time, diagnosis, treatment.
   5. Bill: bill's date, amount.
   6. Payment: for each payment done by the patient towards the bill, the following should be saved: payment date, payment amount, payment type.

Answer rating: 100% (QA)

To create an EntityRelationship Diagram ERD for the given requirements well start by identifying the ... View the full answer