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.
Hospital management system database design
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.
