Draw the ER diagram of a hospital and explain.
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 |
|
|
|
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 |
Describe the Three-Schema Architecture of DBMS. Distinguish Physical Data Independence and Logical Independence.
State the advantages of using database system over file-based information system.
What do you mean by ‘Ternary Relationship’? Define the concept of aggregation with suitable example.
Write the rules of DBA.
What are the differences between AVL Tree & Binary Search Tree ?
Discuss Quality Assurances
Explain Sequence and Activity diagram with example.