MindStudy - MindStudy

Question:

Published on: 21 November, 2024

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

Data Structures & Algorithm C Programming and Practices Computer Graphics and Multimedia Compiler Design Mobile computing Software Engineering

Trending

State the steps involved in query processing. Why is the query optimization needed?

23 January, 2022

Write short notes: B tree

21 November, 2024

Consider the following tables:

DEPT (DCODE, DNAME)

EMP (ECODE, ENAME, BASIC, DCODE, DT_JN)

Write down the SQL statements for the following:

For each department, show DNAME and total basic of the employee in the department.
Find out the names of the department where no person is working.
Find out the names of the employees who are working in the department named as ‘ABC’.
Find out the maximum basic among the employees who have joined after year 2000.

21 November, 2024

Define a Foreign key. Why is the concept needed? How does it play a role in the join operation?

21 November, 2024

Define BCNF. How does it differ from 3NF? Why is it considered stronger than 3NF?

21 November, 2024