Given below is an ER diagram of the Hospital Management Database System. Do the following chronologically:

1. Add at least one aggregation relationship between the entities and explain in detail.

2. Convert the ER diagram including the aggregation relationship into Relational schema and explain in detail each step.

ER Diagram for the Hospital Management Database System:

You can use the following example to include an aggregation relationship to the above ER diagram:

Lastly, convert the completed ER diagram to relational schema explaining each step in detail.

what additional info. do you want?

Treatment price quantity bill Medicine code sex name PID room type address rooms id date governs admitted EID Pdetails Patient assigend Rooms Nurse salary date discharged period E_address attends Employee ISA contact_no sex contact num Doctor Receptionist NID history E_name Trainee ISA visiting maintains Record record_no appoinment Permanent patient_id discription Design #3 with the "Aggregation" feature of the extended ER model If we can represent the relationship between a relationship set and an entity set or between two relationship sets, the above problems can be solved. Extended ER model allows us to aggregate a sub ER model into a single entity set. E1 R1 E2 R2 E3 Figure 7 ER diagram with aggregation No contradiction, No duplication