Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want to make a database that holds information about a small medical practice. Here is a description of the real world situation ( this
I want to make a database that holds information about a small medical practice. Here is a description of the real world situation this is a vastly oversimplified situation
This medical practice is named Alices Health Care.
Patients are registered with the practice.
The practice maintains the following patient information: name, social security number, birthdate, phone number, patientID number, and address.
The patientID number is a number the practice uses to identify a patient so that social security numbers can remain private.
Patients have insurance.
Insurance companies have a name, address, and phone number, and that is all
The practice has doctors. We need to record the doctors name and employeeID number.
A patient is assigned to exactly one doctor
When a patient has a doctors visit, we record the patient, their assigned doctor, the doctor they actually saw the assigned doctor might not be available and the insurance company the patient used for this visit.
Question:
Is the Assigned Doctor relationship to many to or many to many it might be useful to draw your own ER diagram of the situation
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