hospital-management-system-database-design

Hospital management system database design is uploaded in this page. A database is a collection of information and is systematically stored in tables in the form of rows and columns. The table in the database has unique name that identifies its contents. The database in turn is further described in detail giving all the fields used with the data types, constraints available, primary key and foreign key.

Download Hospital management system database design with ER diagram>>


Hostel Management system synopsis>>

SRS documentation for Hospital Management System>>

Hospital management system DFD, CFD, System design

SRS documentation for Hospital Management System>>

Database design is used to manage large bodies of information. In this database we describe all the 4 tables available in the software, which are used to store all the records.

Data types and its description:   

Fields in database table have a data type. Some of the data types used in database table are explained below.

a)   Integer:-

One optional sign character (+ or -) followed by atleast one digit (0-9). Leading and trailing blanks are ignored. No other character is allowed.

b)  Varchar:-

It is used to store alpha numeric characters. In this data type we can set the maximum number of characters upto 8000 ranges by default SQL server will set the size to 50 characters large.

a)   Date/Time:-

Date/Time data type is used for representing data or time.

Patient Table:

Fields Data Type Relationships
Pid Varchar(5) Primary Key
name Varchar(20) Not Null
age int Not Null
weight int Not Null
gender Varchar(10) Not null
address Varchar(50) Not Null
phoneno int Not Null
disease Varchar(20) Not Null
doctorid Varchar(5) Not Null

Doctor Table:

Fields Data Type Relationships
doctorid Varchar(5) Primary Key
doctorname Varchar(15) Not Null
dept Varchar(15) Not  Null

Lab Table:

Fields Data Type Relationships
labno Varchar(5) Primary Key
pid Varchar(5) Not Null
weight int Not Null
doctorid Varchar(5) Foreign Key
date Date/Time Not Null
category Varchar(15) Not Null
patient_type Varchar(15) Not Null
amount int Not Null

Inpatient Table:

Fields Data Type Relationships
pid Varchar(5) Primary Key
room_no Varchar(50) Not Null
date_of_adm Date/Time Not Null
date_of_dis Date/Time Not Null
advance int Not Null
labno Varchar(5) Foreign Key

Outpatient Table:

Fields Data Type Relationships
pid Varchar(5) Primary Key
date Date/Time Not Null
labno Varchar(5) Foreign Key

Room Table:

Fields Data Type Relationships
room_no Varchar(50) Primary Key
room_type Varchar(10) Not Null
status Varchar(10) Not Null

Bill Table:

Fields Data Type Relationships
bill_no Varchar(50) Primary Key
pid Varchar(5) Foreign Key
patient_type Varchar(10) Allow Null
doctor_charge int Not Null
medicine_charge int Not Null
room_charge int Not Null
  • oprtn_charge
int Allow Null
no_of_days int Allow Null
nursing_charge int Allow Null
advance int Allow Null
health_card Varchar(50) Allow Null
lab_charge int Allow Null
bill int Not Null

E-R Diagram

Entity relationship diagram is used in modern database software engineering to illustrate logical structure of database. It is a relational schema database modeling method used to model a system and approach. This approach commonly used in database design. The diagram created using this method is called E-R diagram.

hospital management system er diagram

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

56 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Faisal
Faisal
8 years ago

Where is database of Hospital management sytem.please kindly send me the database to my email id
[email protected]
I really thankful to u

Shiva Prasad
7 years ago
Reply to  Faisal

Kindly download attached file.

koshaba c claire
koshaba c claire
8 years ago

thanks!!!!!!!!!!!!!! can u please direct me on how to design a booking management in micro finance or property management in real estete. if u don’t mind send details to mi email [email protected] thank u very much.

noorki
noorki
8 years ago

please kindly send me the database to my email

[email protected]

i’ll be thankful to you.

thaqif
thaqif
7 years ago
Reply to  noorki

i want source code of hospital management project in java may i get it plz
i’ll be very grateful to u .

my email ([email protected] )

owusu Godbless
owusu Godbless
7 years ago
Reply to  thaqif

plse send me the database to [email protected]

dinesh vishe
dinesh vishe
6 years ago
Reply to  owusu Godbless

send database to [email protected]

Shiva Prasad
7 years ago

Kindly send me the requirements.

koshaba c claire
koshaba c claire
8 years ago

which entities can i consinder when am designing an ER for transaction monitoring in a bank. please reply me!!!!!!!!!!!!!!!

lb
lb
8 years ago

hey,thank yu very much for helping

Shiva Prasad
7 years ago
Reply to  lb

Welcome lb

AnikaSimmons
8 years ago

Been looking for this article for long time ago and finally found here. thanks for sharing this post. appreciate.

Shiva Prasad
7 years ago
Reply to  AnikaSimmons

Welcome Anika Simmons.. Kindly share this website to others.. Hope it helps to all students.

NISHANT KHOKHAR
NISHANT KHOKHAR
8 years ago

can i get the coding part of the hospital management system.
i will be very thankful to you..

propro
propro
8 years ago

Can you please send me coding part..
[email protected]

Shiva Prasad
7 years ago
Reply to  propro

Here is the link to download this project:
https://www.studentprojects.live/page/2/?s=hospital+management

Swarupa Sathe
8 years ago

i want source code of hospital management project in java may i get it plz

Shiva Prasad
7 years ago
Reply to  Swarupa Sathe

Download source code of hospital management system:
https://www.studentprojects.live/page/2/?s=hospital+management

anuja
anuja
8 years ago

Can i get a designs of all tables

Shiva Prasad
7 years ago
Reply to  anuja

Download link is there in the bottom. Click on that.

Gilbert Kemboi
8 years ago

can i get the coding part of the hospital management system.
i will be very thankful to you..

Luis
Luis
8 years ago

Can you please send me the coding part?

[email protected]

Amine Mahamat Amine
8 years ago

i want source code of hospital management project in java may i get it plz
i’ll be very grateful to u .
this is my mail- [email protected]

NICHOLAS MILLS
8 years ago

Please I need the code in Visual Basic …Please send it to my email ([email protected])

Shiva Prasad
7 years ago
Reply to  NICHOLAS MILLS
Mandy
Mandy
8 years ago

can you provide the source code for this project
mail me at [email protected]

Shiva Prasad
7 years ago
Reply to  Mandy

This project is developed in vb.net, java, visual basic 6.0 and in php. Kindly check below link

https://www.studentprojects.live/page/2/?s=hospital+management

sundus temur
sundus temur
8 years ago

plz send me the data base [email protected]

Dauda
Dauda
7 years ago
Reply to  sundus temur

Please send me the database for the hospital management information system [email protected]

nabil
nabil
8 years ago

send me this to my email
[email protected]

sayali
sayali
8 years ago

may i getmini project on music store management with er diagram and all…
i wud b vry thankful…

miss yayad
miss yayad
7 years ago

i want source code and the database of hospital management project in php may i get it please
i’ll be very grateful to u .

([email protected] )

edem kodjo
edem kodjo
7 years ago

please i need the source codes and the database design
my email is [email protected]

Chea Cheat
Chea Cheat
7 years ago

plz give me database of hospital management system . plz sent to me [email protected]

nakato hellen
nakato hellen
7 years ago

pliz kindly send me the database to my email
[email protected]

raj jadhav
raj jadhav
7 years ago

plz send mi the sugar factory management in java…plz plz…
[email protected]

Shiva Prasad
7 years ago
Reply to  raj jadhav

Kindly send me the requirements.

prakash
prakash
7 years ago

i want the source code for whats app can you send me

Shiva Prasad
7 years ago
Reply to  prakash

Sorry we not building any android apps like whatsapp

Dauda
Dauda
7 years ago

I will be very much grateful if you could send me the Hospital Management Information System on this email: [email protected]

Shiva Prasad
7 years ago
Reply to  Dauda

This project is developed in vb.net, java, visual basic 6.0 and in php. Kindly check below link
https://www.studentprojects.live/page/2/?s=hospital+management

prathyusha
prathyusha
7 years ago

i need the complete project of hospital management system if u can pls send me by email [email protected] plz send me as soon as possible for which I will be highly thankful

Shiva Prasad
7 years ago
Reply to  prathyusha

Hospital management system database design already uploaded in this site. Check the below link
https://www.studentprojects.live/studentprojectreport/er-diagram/hospital-management-system-database-design/
Even I sent mail to you..

Shiva Prasad
7 years ago
Reply to  prathyusha