Question

create an entity relationship diagram.

You are to create a small DB for a hospital. The DB should contain the information about patients and physicians. Attributes of physicians include physician ID (identifier), name(first and Last) and specialization. Every patient has a name (first and last) and a unique patient ID. When a patient is admitted to the hospital, the patient must be assigned a physician in charge of the admission procedure. For every admission, the date of the admission to the hospital is stored. A physician may optionally oversee the admission procedure for any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (treatment day, time, and the results).

Answer 1

Here is the ER diagram with following entites:

Patient: patient_id, first_name, last_name

Admission: admission_date, patient_id

Physician: physician_id, first_name, last_name, specialization

Treatment Records: patient_id, treatment_date, treatment_time, results