28 Sep '12

Shiva Prasad

Hello all, I am collecting resources from different sources and Our freelance developers are developing VB.Net, ASP.Net, PHP, ASP, JAVA, Android projects, C# Programming, C and C++ programming projects for IT, Diploma and engineering students.

12 Shares

Hospital management system database design

Advertisements

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.

hospital management system er diagram

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



Related Posts

  • Faisal

    Where is database of Hospital management sytem.please kindly send me the database to my email id
    nite_walqer@yahoo.com
    I really thankful to u

    • admin

      Open hospital management system project synopsis. and and click download link.
      Database also you can download in this.

    • http://www.freestudentprojects.com/ Shiva Prasad

      Kindly download attached file.

  • koshaba c claire

    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 koshabac@yahoo.com thank u very much.

    • noorki

      please kindly send me the database to my email

      noorki1090@gmail.com

      i’ll be thankful to you.

      • thaqif

        i want source code of hospital management project in java may i get it plz
        i’ll be very grateful to u .

        my email (thakeef1@yahoo.com )

    • http://www.freestudentprojects.com/ Shiva Prasad

      Kindly send me the requirements.

  • koshaba c claire

    which entities can i consinder when am designing an ER for transaction monitoring in a bank. please reply me!!!!!!!!!!!!!!!

  • lb

    hey,thank yu very much for helping

    • http://www.freestudentprojects.com/ Shiva Prasad

      Welcome lb

  • http://alinesullivan.webstarts.com/ AnikaSimmons

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

    • http://www.freestudentprojects.com/ Shiva Prasad

      Welcome Anika Simmons.. Kindly share this website to others.. Hope it helps to all students.

  • NISHANT KHOKHAR

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

  • propro

    Can you please send me coding part..
    unknown111@windowslive.com

  • http://www.facebook.com/swarupa.sathe.9 Swarupa Sathe

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

  • anuja

    Can i get a designs of all tables

    • http://www.freestudentprojects.com/ Shiva Prasad

      Download link is there in the bottom. Click on that.

  • http://www.facebook.com/gilbert.kemboi.5496 Gilbert Kemboi

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

  • Luis

    Can you please send me the coding part?

    luisgonf@hotmail.com

  • http://www.facebook.com/ibnumahamat Amine Mahamat Amine

    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- ibnumahamat@hotmail.com

  • http://twitter.com/profkay60 NICHOLAS MILLS

    Please I need the code in Visual Basic …Please send it to my email (b_tolive@yahoo.com)

  • Mandy

    can you provide the source code for this project
    mail me at yyeahgrp@gmail.com

  • sundus temur

    plz send me the data base honeyeye61@yahoo.com

    • Dauda

      Please send me the database for the hospital management information system ajay58sl@gmail.com

  • nabil

    send me this to my email
    nabilhabib4@gmail.com

  • sayali

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

  • miss yayad

    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 .

    (missyayad@gmail.com )

  • edem kodjo

    please i need the source codes and the database design
    my email is edemhed@yahoo.com

  • Chea Cheat

    plz give me database of hospital management system . plz sent to me cheacheat.kh@gmail.com

  • nakato hellen

    pliz kindly send me the database to my email
    nakhellen@gmail.com

  • raj jadhav

    plz send mi the sugar factory management in java…plz plz…
    rajjadhav1317@gmail.com

    • http://www.freestudentprojects.com/ Shiva Prasad

      Kindly send me the requirements.

  • prakash

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

    • http://www.freestudentprojects.com/ Shiva Prasad

      Sorry we not building any android apps like whatsapp

  • Dauda

    I will be very much grateful if you could send me the Hospital Management Information System on this email: ajay58sl@gmail.com

  • prathyusha

    i need the complete project of hospital management system if u can pls send me by email prathyusha6969@gmail.com plz send me as soon as possible for which I will be highly thankful