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

Shiva Prasad

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.


Leave a Reply

Your email address will not be published. Required fields are marked *

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