Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Hospital management system database design

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.

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:

FieldsData TypeRelationships
PidVarchar(5)Primary Key
nameVarchar(20)Not Null
ageintNot Null
weightintNot Null
genderVarchar(10)Not null
addressVarchar(50)Not Null
phonenointNot Null
diseaseVarchar(20)Not Null
doctoridVarchar(5)Not Null

Doctor Table:

FieldsData TypeRelationships
doctoridVarchar(5)Primary Key
doctornameVarchar(15)Not Null
deptVarchar(15)Not  Null

Lab Table:

FieldsData TypeRelationships
labnoVarchar(5)Primary Key
pidVarchar(5)Not Null
weightintNot Null
doctoridVarchar(5)Foreign Key
dateDate/TimeNot Null
categoryVarchar(15)Not Null
patient_typeVarchar(15)Not Null
amountintNot Null

Inpatient Table:

FieldsData TypeRelationships
pidVarchar(5)Primary Key
room_noVarchar(50)Not Null
date_of_admDate/TimeNot Null
date_of_disDate/TimeNot Null
advanceintNot Null
labnoVarchar(5)Foreign Key

Outpatient Table:

FieldsData TypeRelationships
pidVarchar(5)Primary Key
dateDate/TimeNot Null
labnoVarchar(5)Foreign Key

Room Table:

FieldsData TypeRelationships
room_noVarchar(50)Primary Key
room_typeVarchar(10)Not Null
statusVarchar(10)Not Null

Bill Table:

FieldsData TypeRelationships
bill_noVarchar(50)Primary Key
pidVarchar(5)Foreign Key
patient_typeVarchar(10)Allow Null
doctor_chargeintNot Null
medicine_chargeintNot Null
room_chargeintNot Null
oprtn_chargeintAllow Null
no_of_daysintAllow Null
nursing_chargeintAllow Null
advanceintAllow Null
health_cardVarchar(50)Allow Null
lab_chargeintAllow Null
billintNot 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

Comments ( 56 )

  1. hey,thank yu very much for helping

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

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

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

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

  6. Can i get a designs of all tables

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

  8. Can you please send me the coding part?

    [email protected]

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

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

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

  12. plz send me the data base [email protected]

  13. send me this to my email
    [email protected]

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

  15. 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] )

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

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

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

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

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

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

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

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

  24. can i use the attributes for the lab table in a table named lab results

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

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in Android, 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.

Follow Me