Scribd
Upload
26 views1 page

Hospital Entity Relationship Diagram (ERD)

Uploaded by

msfares2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views1 page

Hospital Entity Relationship Diagram (ERD)

Uploaded by

msfares2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Entity Relationship Digram (ERD)

Hospital
Id PK int
Name string
Address string
PhoneNumber int

Clinic EmployeeClinic Employee


Id PK int EmployeeId FK int Id PK int
Name string ClinicId FK int Name string
NumberOfEmployees int Salary decimal
PhoneNumber string Address string
Phone int

Doctor Nurse
Id FK int Id FK int
MedicalSpecialty string WorkingHours int
MedicalHistory int

Laboratory Test Patient


Id PK int Id PK int Id PK int
LabNumber int Description string Illness string
NumberOfRooms int Date date Age int
Device_Id FK int LaboratoryId FK int DoctorId FK int
NurseId FK int
DischargeDate date
DischargeStatus string
Bill decimal
Devices
Id PK int
DeviceName string

You might also like