Question

Question:
a.Identify Entities, their attributes and relationships among the entities for the given scenarios and present in a preliminary ER-Diagram.
b. Identify all existing Super key, candidate key, primary key, foreign key, composite key, derived key and partial key for any one entity type of each scenario.
SCENARIO:
You have been hired by a regional hospital to create a database that will track the procedures performed for patients and the corresponding billing information. To ease the storing of this information, the hospital assigns each new patient a unique patient number. Often, the same patient may be seen by the hospital for different procedures, and will, therefore, keep the same unique number. The hospital needs a database system that is able to track all procedures performed for a patient and can bill him or her individually for the visits.

Answer 1

Answer:

All the information given in here, refer the attached files.

Explanation:

The main entities of the Hospital Management System are Hospitals, Patient, Doctors, Nurses, Appointments and Medicines.

bf9681542e504708862503770fa775f7.pdf