Explain in detail the given ER diagram of the Management Database System [what each of the entities is doing in detail]. Describe each entity and the relationship existing between each entity and reason out why you chose that specific relationship multiplicity such as one-to-one.

Add at least one aggregation relationship between the entities.

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