Hospital Management System Database Design

ER Diagram for Hospital Management System

This Hospital Management System Database Design has an ER Diagram for Hospital Management System project.

This material includes database schema, Data dictionaries, Database Tables and ERD.

What is Hospital Management System Database Design?

The Hospital management system database design is a database design use for managing hospital functions and events. It enables the admin to register a patient for the hospital, stores their disease details into the database. Any of the staff members, doctor & admin is able to add, view, edit, update or delete data.

What is the purpose of Hospital management System database?

The purpose of the Hospital Management System database Design is to make a secure and easy way of storing information of the patient, doctors, inpatient, outpatient, Rooms, and Bill payment.

What are the Features of the Hospital Management System Database Design?

There are seven(7) common features of Hospital Management System Database Design such as Managing Patients, Doctors, laboratory, Inpatient, Outpatient, Rooms, and Hospital Bills information.

ER Diagram for Hospital Management System

ER Diagram Hospital Management System Database Design Project.

  • Manage Patients

    This table of ER Diagram Hospital Management System will be used for storing and managing the patient information.

  • Manage Doctor

    This table will be used for storing and managing the Doctor information and login account.

  • Manage Laboratory

    This table will be used for storing and managing the Laboratory transaction.

  • Manage Inpatient

    This table will be used for storing and managing the inpatient information and diagnosis.

  • Manage Outpatient

    This table will be used for storing and managing the inpatient information and diagnosis.

  • Manage Room

    This table will be used for storing and managing the room information and assigning of patient in every room.

  • Manage Bills

    The billing table will be used for managing the statement of accounts per patient and for the collection of bills.

ER Diagram for Hospital Management System with Relationship

This section will show you the ER Diagram for Hospital Management System Project.

In the image below you see the actual relationship of all entity.

Diagram of Hospital Management System

ER Diagram for Hospital Management System Project

Figure 8: Proposed SCA Hospital Management System Entity Relationship Diagram

Based on figure 8, the proposed er diagram for hospital management system with relationship shows the entity of the proposed SCA Hospital Management system database, which is presented by tables; the tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

Table 1: tblPatient

Field NameDescriptionTypeLength
patient_id (PK)Patient IDvarchar10
namePatient Namevarchar50
age               Patient  Ageint3
genderPatient Gendervarchar50
addressPatient Addressvarchar50
diseasePatient Diseasevarchar50
doctor_id (FK)Doctor IDvarchar20

Table 2: tblDoctor

Field NameDescriptionTypeLength
doctor_id (PK)Doctor IDvarchar10
name   Doctor Namevarchar30
ageDoctor Ageint3
genderDoctor gendervarchar50
addressDoctor Addressvarchar50

Table 3: tblLab

Field NameDescriptionTypeLength
lab_no (PK)Laboratory Numbervarchar10
patient_id (FK)             Patient IDvarchar10
doctor_id (FK)             Doctor IDvarchar10
date             Laboratory  DateDate/Time10
amountAmount of Labint20

Table 4: tblInpatient

Field NameDescriptionTypeLength
patient_id (PK)Patient IDvarchar10
room_no (FK)Room Numbervarchar50
date_of_admDate of Admission    Date/Time10
date_of_disDate of Discharge    Date/Time10
lab_no (FK)Laboratory Numbervarchar10

Table 5: tblOutpatient

Field NameDescriptionTypeLength
patient_id (PK)Patient IDvarchar10
dateDate of Outpatientvarchar10
lab_no (FK)Laboratory Numbervarchar20

Table 6: tblRoom

Field NameDescriptionTypeLength
room_no (PK)Room Numbervarchar50
room_typeRoom Typevarchar50
statusStatus Of Roomvarchar20

Table 7: tblBill

Field NameDescriptionTypeLength
bill_no (PK)Patient IDint11
patient_id (FK)Patient Namevarchar10
doctor_charge               Patient  Ageint10
room_chargePatient Genderint10
no_of_daysPatient Addressint           10
lab_chargePatient Diseaseint10
billDoctor IDint10

If you have any question or suggestion about ER diagram hospital management system project, please feel free to contact us or simply leave a comment below.

Conclusion

This Hospital Management System Database Design is a requirement in the DBMS mini Project.

If you want to develop your own Hospital Management System, you can upgrade this database design to suit your requirements.

 

3 thoughts on “Hospital Management System Database Design”

  1. Hello Gays,
    Hope you are doing well!

    I’m taking a course in MS SQL server, and I have a capstone project in Jan-2023, so I need your help to build a database system related to the flow of patients from when they entered the hospital until they go home.

    Thank you!

  2. where are the relations b\w these entities.i feel hard to understand the relationship b\w them. There should be amendments. thank you btw this one suits me well.

Leave a Comment