5) Hospital Management System ER Diagram:
+-------------+
| Patient |
+-------------+
| patient_id (PK)|
| name |
| dob |
| address |
+-------------+
|
|
+---------+---------+
| |
+-------+-------+ +-------+-------+
| Admits | | Doctor |
| | +---------------+
+---------------+ | doctor_id (PK)|
| admit_id (PK) | | name |
| patient_id (FK)| | specialization|
| doctor_id (FK)| +---------------+
| admit_date |
| discharge_date|
+---------------+
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter