Question: Using the Crows Foot notation, create an ERD that can be implemented for a physical therapy clinic using the following business rules: -A patient can
Using the Crows Foot notation, create an ERD that can be implemented for a physical therapy clinic using the following business rules: -A patient can make many appointments with one or more therapists in the clinic, and a therapist can accept appointments with many patients. However, each appointment is made with only one therapist and one patient. -The clinic accepts walk-in cases that do not require an appointment. However, for appointment management purposes, a walk-in appointment is entered in the appointment book as unscheduled. -If kept, an appointment yields a visit with the therapist specified in the appointment. The visit yields the condition they are receiving treatment for, an evaluation of the condition and, when appropriate, treatment. -With each visit, the patients records are updated to provide a medical history. -Each patient visit creates a bill. Each patient visit is billed by one therapist, and each therapist can bill many patients. -Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. -A patient may pay the bill directly, or the bill may be the basis for a claim submitted to an insurance company. -If the bill is paid by an insurance company, the deductible is submitted to the patient for payment.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
