Free Student Projects

Follow

Advertisement

Hospital management system database design

Share

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

Advertisement

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:

Advertisement

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:

facebook

Hostel Management system synopsis>>

SRS documentation for Hospital Management System>>

Hospital management system DFD, CFD, System design

SRS documentation for Hospital Management System>>

Advertisement

Share

Related

Advertisement

Latest

Advertisement