CSE $3153$ Lab $1$

Part $2$:

Create a high level E$/$R diagram for the hospital including all entities and relationships

Add your attributes to each entity you have drawn.

This is the first part of the lab I made:

$1.$ Patient Care Administration $($Business Function$)$

Entities:

Patient

Doctor

Nurse

Appointment

Medical Record

$2.$ Clinical Services $($Business Function$)$

Entities:

Patient

Lab Test

Radiology Report

Prescription

Treatment Plan

$3.$ Billing and Finance $($Business Function$)$

Entities:

Patient

Invoice

Payment

Insurance Claim

Billing Code

$4.$ Human Resources $($Business Function$)$

Entities:

Employee

Job Position

Payroll

Training Program

Performance Review

$5.$ Information Technology $($Business Function$)$

Entities:

IT System

User Account

Software Application

Hardware Device

Network Infrastructure

$6.$ Supply Chain Management $($Business Function$)$

Entities:

Supplier

Inventory Item

Purchase Order

Delivery Schedule

Warehouse