Hospital Relationship Entity Diagram

Patient

PatientID: String, PK

SectorId: String, FK

FirstName: String

LastName: String

DateAdmitted: String

Age: Number

RoomID: String, FK

BedID: String, FK

Sector

SectorID: String, PK

RoomsListID: String, FK

DoctorsListID: String, FK

Doctors

DoctorListID: String, PK

DoctorId: String, FK

Doctor

DoctorID: String, PK

FirstName: String

LastName: String

YearsOfExperience: Number

SectorID: String, FK

BedListID: String, FK

Nurse

StaffID: String, PK

FirstName: String

LastName: String

YearsOfExperience: Number

BedListID: String, FK

Bed

BedID: String, PK

IsOccupied: Boolean

PatientId: String, FK

RoomID: String, FK

Beds

BedListID: String, PK

BedID: String, FK

Room

RoomID: String, PK

Floor: String

Building: String

NumOfBeds: Number

OccupiedBeds: Number

SectorID: String, FK

BedListID: String, FK

Rooms

RoomListID: String, PK

RoomID: String, FK

One to Many

One To One

One To Many

One To One

One To Many

One To One

One To One

Many to One

Many to One

One To One

One To Many

Many To Many

One To Many