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.
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.

Comments ( 56 )
Where is database of Hospital management sytem.please kindly send me the database to my email id
[email protected]
I really thankful to u
Kindly download attached file.
Open hospital management system project synopsis. and and click download link.
Database also you can download in this.
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.
Kindly send me the requirements.
please kindly send me the database to my email
[email protected]
i’ll be thankful to you.
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] )
plse send me the database to [email protected]
send database to [email protected]
which entities can i consinder when am designing an ER for transaction monitoring in a bank. please reply me!!!!!!!!!!!!!!!