MindStudy - MindStudy

Question:

Published on: 23 February, 2025

Draw the ER diagram of a hospital and explain.

Answer:

ER diagram of Hospital: -

Entity_name	Entity-type	Attributes	Type	Relationship with other entity	Relationship type	Specialization/Generalization
Patient	Strong	Id	Primary key	“Billed for” Treatment, Medicine, Equipment	Fully dependent on “Billed for”
		Name	Simple
		Address	Simple
		Sex	Simple
		Age	Derived
		Info	Multivalued
		Contact_no	Multivalued
		Date_admitted	Simple
		Date_discharge	Simple
Treatment	Weak				Fully dependent on “Billed for”
Medicine	Strong	Code	Primary key
		Price	Simple
		Description	Simple
Equipment	Weak	Price	Simple
Equipment	Weak	Description	Discriminator
Room	Strong	Room_id	Primary key	Is “Assigned” for Patient
		Type	Simple
		Extension	Simple
Employee	Strong	Id	Primary key			Generalized for Doctor, Nurse, Receptionist
		Name	Simple
		Sex	Simple
		Salary	Simple
		Contact_info	Multivalued
		Qualification	Simple
		Experience	Simple
Doctor	Strong			“Attends” Patient		Specialized entity of Employee, Generalized for Visiting, Permanent, Trainee
Visiting	Strong					Specialized entity of Doctor
Permanent	Strong					Specialized entity of Doctor
Trainee	Strong					Specialized entity of Doctor
Nurse	Strong			“Governs” Room	“Governs” relationship is Fully dependent on “Nurse”	Specialized entity of Employee
Receptionist	Strong			“Maintains” Record		Specialized entity of Employee
Record	Strong	Record_no	Primary key
		Patients_info	Multivalued
		Appointment	Simple

Subjects

Design and Analysis of Algorithm Software Engineering Compiler Design C Programming and Practices Computer Graphics and Multimedia Data Structures & Algorithm

Trending

State the advantages of using database system over file-based information system.

23 February, 2025

Describe the Three-Schema Architecture of DBMS. Distinguish Physical Data Independence and Logical Independence.

23 February, 2025

What are the differences between Primary Index, Secondary Index, and Clustering Index?

23 February, 2025

Discuss the ACID properties of transaction.