Ask
Login
1
610kviews
Draw E-R diagram for Hospital management System.
written 8.7 years ago by gravatar for teamques10 teamques10 ★ 69k modified 3.0 years ago by gravatar for jaypanchal90968 jaypanchal90968 • 20
database management systems
ADD COMMENT EDIT
1 Answer
29
28kviews
written 8.7 years ago by gravatar for teamques10 teamques10 ★ 69k

Step 1: E-R Diagram

enter image description here

Step 2: Converting the E-R Diagram into Tables

b. Converting entity to table and attribute to columns

Hospital

Hosp-id Primary Key
HCity  
HAddress  
Hos-Name  
Pat-id Foreign key references to Pat-id of Patient table
Doc-id Foreign key references to Doc-id of Doctor table

Patient

Pat-id Primary Key …

Create a free account to keep reading this post.

and 3 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.