This medical practice is named Alice$$s 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 $5$ doctors. We need to record the doctor$$s 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.

$1$notes$02$ Extensions:

Instead of having only doctors, we will have doctors and Physicians Assistants.

Doctors and Physician assistants are both employees of the clinic.

The information stored about doctors and physician assistants are identical