Design Normalize Database Hospital Management System project DBMS

⭕ Micro-Project : Design Normalize Database Hospital Management System. ⭕

Rationale

            In this project we are tried to show the working of some important tasks in Hospital Management System and cover the basic functionality of a patients record System. 

In the present era of globalization and advanced technology efficient record keeping cannot be overemphasized. Imagine the scenario when the manual processes and manual modes of instruction get replaced with electronic systems. 

One of such replacement can be done in the area of patient’s database management system within a hospital. Developing patient database management system software would benefit the hospital management who can have effortless access to the data securely and more easily. 

Libraries keeps information on how many books are in the library, how many are been loaned out and to whom they are loaned and also the date and time this books were loaned or given out. School also keeps student’s information or records. These records of students could include student’s personal data such as name, date of birth, level etc.

 

Aim of the Micro-Project

Develop C Program for Design Normalize Database Hospital Management System.

Course Outcomes 

·        Design Normalized database on given data.

·        Create and Manage Database using SQL command.

·        Write PL/SQL code for given database.

·        Apply triggers 0b database also create procedure and function according to condition.

·        Apply security and confidentiality on given Database.

Literature Review

Health care in Nigeria as in many other countries is confronted with growing demand for medical treatment and services, due to factors such as a graying population and higher standard for the quality of life. 

Miller , say that health care has been an issue of growing importance for national government. Many national and regional health care plans have been developed in the past decades, in order to control the cost, quality and the availability of health care for all citizens. Brown , opined that the application of electronic clinical information system (ECIS) has generated useful insight into the quality of data accuracy and health care provision in primary care settings. 

This is partly one of the adapted style and approach to data entry influenced by the design presented by the recent structure. They further emphasize, that there is a great need for improved education and protocols for consisting data entry in the (ECIS) and also subsequent follow up of patient clarification on the policy for duration and frequency treatment. Lauber , define medical, health record, or medical documentation of a patient’s medical history and care as “medical record” used both as the physical folder of patients and for the body of information 

which comprises the total of each patient’s health history. Medical records are intensely personal document and there are many ethical and legal issues surrounding them such as the degree of third-party access and appropriate storage and disposal. The key advantage of shifting to computer-based patient record is the opportunity to strengthen the link between the hospital records and management information system so that resources uses and quality of care can be analyzed using Hospital database which increase physician efficiency and reduce costs, as well as promote standardization of care.

 

Proposed Methodology

From collected information about Hospital Management Systems. Design Normalized database on given data.

1. Started collecting information on the given topic.

 2. To draw the ER diagram.

3. Normalized data first to third normal form

_____________________________________

                        Report : Develop c program for employee record system.

 

Rationale

    In this project we are tried to show the working of some important tasks in Hospital Management System and cover the basic functionality of a patients record System. 

In the present era of globalization and advanced technology efficient record keeping cannot be overemphasized. Imagine the scenario when the manual processes and manual modes of instruction get replaced with electronic systems. 

One of such replacement can be done in the area of patient’s database management system within a hospital. Developing patient database management system software would benefit the hospital management who can have effortless access to the data securely and more easily. Libraries keeps information on how many books are in the library, how many are been loaned out and to whom they are loaned and also the date and time this books were loaned or given out. 

School also keeps student’s information or records. These records of students could include student’s personal data such as name, date of birth, level etc.

Aim of the Micro-Project 

Develop C Program for Design Normalize Database Hospital Management System.

 

Course Outcomes  

·        Design Normalized database on given data.

·        Create and Manage Database using SQL command.

·        Write PL/SQL code for given database.

·        Apply triggers 0b database also create procedure and function according to condition.

·        Apply security and confidentiality on given Database. 

 

Literature Review

Health care in Nigeria as in many other countries is confronted with growing demand for medical treatment and services, due to factors such as a graying population and higher standard for the quality of life. 

Miller, say that health care has been an issue of growing importance for national government. Many national and regional health care plans have been developed in the past decades, in order to control the cost, quality and the availability of health care for all citizens. Brown, opined that the application of electronic clinical information system (ECIS) has generated useful insight into the quality of data accuracy and health care provision in primary care settings. 

This is partly one of the adapted style and approach to data entry influenced by the design presented by the recent structure. They further emphasize, that there is a great need for improved education and protocols for consisting data entry in the (ECIS) and also subsequent follow up of patient clarification on the policy for duration and frequency treatment. 

Label, define medical, health record, or medical documentation of a patient’s medical history and care as “medical record” used both as the physical folder of patients and for the body of information which comprises the total of each patient’s health history. Medical records are intensely personal document and there are many ethical and legal issues surrounding them such as the degree of third-party access and appropriate storage and disposal.

 

Definition of Basic Terms Data:

A collection of fact on which conclusions maybe drawn.

Hospital: An institution that provides medical, surgical or psychiatric care and treatment for the sick or the injured.

Patient: One who receives medical treatment attention care.

Medical records: It’s any data, which is collected and use to diagnose or treat a patient’s health problem.

Database: A collection of data arranged for ease and speedy search and retrieve.

 

Aim of Hospital Management System: 

·         Store patient record.

 

Database Design Database:

is a collection of structure and related record (information) stored somewhere or some location for easy retrieval and exploration. Database is designed in order to assist in eliminating unnecessary data and to minimize duplication of data.( see Appendix)

Database Normalization :

Normalization is the organization of data to conform to a standard called Normal form and for efficient manipulation, storage and update of data. (See Appendix)

ER Diagram Hospital Management System Database:

 

·         Manage Patients

This table of ER Diagram Hospital Management System will be used for storing and managing the patient information.

·         Manage Doctor

This table will be used for storing and managing the Doctor information and login account.

·         Manage Laboratory

This table will be used for storing and managing the Laboratory transaction.

·         Manage Inpatient

This table will be used for storing and managing the inpatient information and diagnosis.

·         Manage Outpatient

This table will be used for storing and managing the inpatient information and diagnosis.

·         Manage Room

This table will be used for storing and managing the room information and assigning of patient in every room.

·         Manage Bills

The billing table will be used for managing the statement of accounts per patient and for the collection of bills.

ER Diagram for Hospital Management System with Relationship:

This section will show you the ER Diagram for Hospital Management System Project. In the image below you see the actual relationship of all entity.

Diagram of Hospital Management System :

 

 

Table 1: tblPatient (1NF)

Field Name	Description	Type	Length
patient_id (PK)	Patient ID	varchar	10
name	Patient Name	varchar	50
age	Patient  Age	int	3
gender	Patient Gender	varchar	50
address	Patient Address	varchar	50
disease	Patient Disease	varchar	50
doctor_id (FK)	Doctor ID	varchar	20

 

 

Table 2: tblDoctor (2NF)

Field Name	Description	Type	Length
doctor_id (PK)	Doctor ID	varchar	10
name	Doctor Name	varchar	30
age	Doctor Age	int	3
gender	Doctor gender	varchar	50
address	Doctor Address	varchar	50

 

Table 3: tblLab (3NF)

Field Name	Description	Type	Length
lab_no (PK)	Laboratory Number	varchar	10
patient_id (FK)	Patient ID	varchar	10
doctor_id (FK)	Doctor ID	varchar	10
date	Laboratory  Date	Date/Time	10
amount	Amount of Lab	int	20

 

Table 4: tblInpatient (4NF)

Field Name	Description	Type	Length
patient_id (PK)	Patient ID	varchar	10
room_no (FK)	Room Number	varchar	50
date_of_adm	Date of Admission	Date/Time	10
date_of_dis	Date of Discharge	Date/Time	10
lab_no (FK)	Laboratory Number	varchar	10

 

Table 5: tblOutpatient (5NF)

Field Name	Description	Type	Length
patient_id (PK)	Patient ID	varchar	10
date	Date of Outpatient	varchar	10
lab_no (FK)	Laboratory Number	varchar	20

 

Table 6: tblRoom (6NF)

Field Name	Description	Type	Length
room_no (PK)	Room Number	varchar	50
room_type	Room Type	varchar	50
status	Status Of Room	varchar	20

 

Table 7: tblBill (7NF)

Field Name	Description	Type	Length
bill_no (PK)	Patient ID	int	11
patient_id (FK)	Patient Name	varchar	10
doctor_charge	Patient  Age	int	10
room_charge	Patient Gender	int	10
no_of_days	Patient Address	int	10
lab_charge	Patient Disease	int	10
bill	Doctor ID	int	10

Actual Methodology Followed 

1. Started collecting information on the given topic.

 2. To draw the ER diagram.

3. Normalized data first to seven normal form

 

Normalization :

Database Type	Tables
Denormalized	Patient ID,Patient Name,Patient  Age,Patient Gender,Patient Address,Patient Disease,Doctor ID
Normalized(1NF)	Doctor ID,Doctor Name,Doctor Age,Doctor gender,Doctor Address
Normalized(2NF)	Laboratory Number,Patient ID,Doctor ID,Laboratory  Date,Amount of Lab
Normalized(3NF)	Laboratory Number,Patient ID,Doctor ID,Laboratory  Date,Amount of Lab
Normalized(4NF)	Patient ID,Room Number,Date of Admission,Date of Discharge,Laboratory Number
Normalized(5NF)	Patient ID,Date of Outpatient,Laboratory Number
Normalized(6NF)	Room Number,Room Type,Status Of Room
Normalized(7NF)	Patient ID,Patient Name,Patient  Age,Patient Gender,Patient Address,Patient Disease,Doctor ID

 

Actual Resources Used 

S. No.	Name of Resources/material	Specifications	Qty	Remarks
1	Laptop	Core i5 -2.3 GHz  8 GB Ram 64-bit operating system-windows 10	1	----
2	Software	Oracal	--	----
3	Other resources	Internet, YouTube	--	----

Skill Developed

•      Ability to perform a team work
•      Communicate effectively in order and written 
•      To finding error

•      Communication with team member as a leader or member

Conclusion

    This Hospital Management System Database Design is a requirement in the DBMS mini Project. if you want to develop your own Hospital Management System, you can upgrade this database design to suit your requirements.

 

***************