Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the Crow s Foot methodology and Erwin Data Modeler, create an ERD that can be implemented for a medical clinic, using at least the
Using the Crows Foot methodology and Erwin Data Modeler, create an ERD that can
be implemented for a medical clinic, using at least the following business rules:
A patient may make many appointments in the clinic.
A doctor may accept appointments with many patients.
Each appointment is made with only one doctor and one patient.
Emergency cases do not require an appointment. However, for appointment
management purposes, an emergency is entered in the appointment book as
unscheduled
If kept, an appointment yields a visit with the doctor specified in the appointment. Each
visit is recorded by only one doctor and attended by only one patient.
Each visit yields one or more visit details. There are two kinds of visit details: diagnosis
and treatment.
Each visit must create a bill. A bill is created for one visit.
Each bill must be paid by one or many payments. The payment type indicates if the
payment is from a patient or an insurance company.
A payment may be from a patient or an insurance company.
A patient may be insured by one or more insurance companies.
A patient or an insurance company may make many payments.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started