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.
Comments ( 56 )
hey,thank yu very much for helping
Welcome lb
Been looking for this article for long time ago and finally found here. thanks for sharing this post. appreciate.
Welcome Anika Simmons.. Kindly share this website to others.. Hope it helps to all students.
can i get the coding part of the hospital management system.
i will be very thankful to you..
here is the source code:
https://studentprojects.live/page/2/?s=hospital+management
Can you please send me coding part..
[email protected]
Here is the link to download this project:
https://studentprojects.live/page/2/?s=hospital+management
i want source code of hospital management project in java may i get it plz
Download source code of hospital management system:
https://studentprojects.live/page/2/?s=hospital+management
Can i get a designs of all tables
Download link is there in the bottom. Click on that.
can i get the coding part of the hospital management system.
i will be very thankful to you..
Kindly check this https://studentprojects.live/page/2/?s=hospital+management
Can you please send me the coding part?
[email protected]
Check this: https://studentprojects.live/page/2/?s=hospital+management
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]
JAVA based hospital management system:
Please I need the code in Visual Basic …Please send it to my email ([email protected])
This project is developed in visual basic 6.0
can you provide the source code for this project
mail me at [email protected]
This project is developed in vb.net, java, visual basic 6.0 and in php. Kindly check below link
https://studentprojects.live/page/2/?s=hospital+management
plz send me the data base [email protected]
Please send me the database for the hospital management information system [email protected]
send me this to my email
[email protected]
may i getmini project on music store management with er diagram and all…
i wud b vry thankful…
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] )
please i need the source codes and the database design
my email is [email protected]
plz give me database of hospital management system . plz sent to me [email protected]
pliz kindly send me the database to my email
[email protected]
plz send mi the sugar factory management in java…plz plz…
[email protected]
Kindly send me the requirements.
i want the source code for whats app can you send me
Sorry we not building any android apps like whatsapp
I will be very much grateful if you could send me the Hospital Management Information System on this email: [email protected]
This project is developed in vb.net, java, visual basic 6.0 and in php. Kindly check below link
https://studentprojects.live/page/2/?s=hospital+management
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
Even you can check in this too:
https://studentprojects.live/page/2/?s=hospital+management
Hospital management system database design already uploaded in this site. Check the below link
Even I sent mail to you..
hey can u please mail me the hospital management system project using sql as backend and java as frontend as soon as possible. in urgent
thank you!
email id:
[email protected]
can i use the attributes for the lab table in a table named lab results
hi
i need the complete project of hospital management system if u can send me by email [email protected] plz send me I will be highly thankful
Complete project uploaded in this site. You can directly download from here itself
Can You please send me RDbms system of a hospital in a flow chart at [email protected]
where can i download the schema
can you send by mail