Question
Using the below business rules for patient appointment relationship, draw an Entity Relationship Diagram that reflects the relationships. Diagram should be drawn using Microsoft Visio.
Using the below business rules for patient appointment relationship, draw an Entity Relationship Diagram that reflects the relationships. Diagram should be drawn using Microsoft Visio.
The tables you will be using for the diagram are highlighted in bold and underlined. Please pay attention to the relationships. Relationships could be a One-to-One, One-to-Many, or Many-to-Many. If there happens to be a Many-to-Many relationship, then a linking table will have to be created for the Many-to-Many relationship. Each of the tables should have fields/columns.
In your diagram, make sure to include the fields including primary key and foreign keys like PatientID, PaymentID etc.
Please see business requirement below.
Patient makes an appointment to see a doctor
The appointment is for a particular date and time
The patient is assigned to a doctor but if this doctor is not available, the patient is allowed to see the other available doctors
After treatment, the patient makes a co-pay payment
The patient is insured by an insurance company
The insurance company makes the remaining payment
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