and 3 others joined a min ago.
1
570kviews
Draw E-R diagram for Hospital management System.
written 7.8 years ago by
teamques10
★ 65k
|
modified 2.1 years ago
by
jaypanchal90968
• 20
|
ADD COMMENT
EDIT
1 Answer
28
27kviews
|
written 7.8 years ago by
teamques10
★ 65k
|
Step 1: E-R Diagram
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 … |
|---|
and 3 others joined a min ago.
ADD COMMENT
EDIT
Please log in to add an answer.