Automated Hospital Bed Allocation System

Project and Seminar Material for Computer Science and Computer Engineering

Automated Hospital Bed Allocation System


In developing countries, the management of in-patient bed allocation is increasingly becoming complex as a result of inadequate bed capacity, poor scheduling policies and financial constraints in hospitals. The use of a decision based system could aid hospital staff and health decision-makers to carry out efficient in-patient beds allocation, thus potentially reducing costs and in-patient length of stay. This study developed a Decision Based Management System for Hospital Bed Allocation in other to enhance easy accessibility and efficient bed allocation in the hospital in a fairly and timely manner using State Specialist Hospital, Akure, Ondo State, Nigeria as case study and Microsoft Visual Studio, C#, and SQL SERVER 2005 tools for the implementation. The analysis of the manual method served as the input used to developed and experiment the functionalities of the proposed system.

Table of Content

  • Title page
  • Approval page
  • Dedication
  • Acknowledgement
  • Abstract
  • Table of contents

Chapter One:

General Introduction

  • 1.1 Historical Background
  • 1.2 Statement of Problem
  • 1.3 Aim and Objectives
  • 1.4 Scope of the Study
  • 1.5 Limitation of the Study
  • 1.6 Significance of The Study
  • 1.7 Definition of Terms

Chapter Two:

Literature Review

  • 2.1 E-Health
  • 2.2. Automation
  • 2.3 Database Management System
  • 2.3.1 Function of DBMS
  • 2.4 Information System
  • 2.4.1 Types of Information System
  • 2.4.2 Transaction Processing Systems
  • 2.4.3 Management Information Systems
  • 2.4.4 Decision Support Systems

Chapter Three:

Research Methodology

  • 3.1 Introduction
  • 3.2 Research Design
  • 3.2.1 Method of Development
  • 3.3 Validating/Evaluation

Chapter Four:

Implementation, Result and Discussion

  • 4.1.1 Implementation
  • 4.1.2 Choice of Programming
  • 4.1.3 Proposed System Procedure
  • 4.3 Files to Be Maintained
  • 4.3 Discussion
  • 4.4 Problem Encountered
  • 4.5 System Documentation
  • 4.5.1 User Manual
  • 4.6 System Flow Chart / Algorithm

Chapter Five:

Conclusion and Recommendation

  • 5.1 Conclusion
  • 5.2 Recommendation
  • Reference

Chapter One

General Introduction

1.1 Historical Background

A project work is a piece of works involving careful study, design to produce information about an idea or entity to produce a new system or to improve an existing one.

In this project is titled computerized hospital space allocation management system, we would see how the records of a prospective patient are brought together using of computer program to accurately process data and allocate bed to each patient base on the data computer is fed with, and procedure of which would enable the management to the number bed allocation.

In order to achieve the aim of the project work in the hospital management, for instance

In the emergency male word, an already bed space allocated to same one is not be allocated to another person else, unless if previous admitted patient is discharged Solving this on admission, because each time a bed space is to be allocated, previous records for the allocated bed spaces and data collected would have to be checked the other.

Hence, with the effect of this project, records of admitted patients would be kept for effective management.

General Hospital Bakura was established in 1979/80 as PHC (Primary Health Care) to cater for health need of the populace in Bakura town.

It was upgraded to Bakura General Hospital in 1996 when Zamfara State was curved out of Sokoto State. It has about 150 bed space comprising 20 space each at 4 wards (male medical, male surgery, female medical and female surgery wards) Maternity has a 40 bed space, 10 bed space at causality. It has 4 units; male medical, surgical, pediatric & maternity units.

The staff strength are 3 doctors, 16 nurses, 15 supporting staffs, 7 lab attendants, 4 pharmacy & 8 medical records officers (53 staffs).

Their red allocation is based on need to do so, by taking relevant information of the patient.

1.2 Statement of Problem

This is the basis for the new system which looks into the problem of the system for an approach in designing the new system to meet with necessary needs. With the manual system of hospital bed space allocation, all information about patients are Collection manually, written with pen on paper and kept for future use or reference purpose. When information stored is to be retrieved, difficulty is encountered, making retrieval tedious due to its value. Effort is therefore being duplicated without achieving perfectly the result of the search due to processing error.

Another problem of this system is the inexistence of perfect security as information could be misplaced, exchanged or tempered with by unauthorized bodies.

1.3 Aim and Objectives

The aim of this project is to change the existing manual method of the hospital bed space allocation to a computerized system and ensure that the purpose of project work is achieved.


The main objective of this study is to investigate the extent and how bed sac is being allocated in Bakura Local Government General Hospital. This breakdown was done as follows:

  1. For easy access to records of discharge patients
  2. To ensure easy store of patients data for useful information towards decision making.
  3. To hinder repetition of bed space allocation while admitted patient is un-discharged.
  4. To find out the process involved.
  5. To find the suitable why to allocate bed space.
  6. To tend out between olden days allocation system and automated system.

1.4 Scope of the Study

The study is attempted to analyze the bed space allocation concept of the hospital and the ways of improving it effectiveness with the aid of computerization.

The study is limited to hospital bed space allocation with research from the general hospital Bakura Zamfara state.

1.5 Limitation of the Study

The limitation of this study includes:

  1. Inability to give definite bed space to patients.
  2. Inability to detect word for word an already allocated bed space.

1.6 Significance of the Study

My research hypothesis is believed that there is no significant with the current bed allocation in hospital. The significance of this research is multi-dimensional those to advice benefit have been categorized:

  1. Government of all level
  2. The general public
  3. Academicians in fluttering research, findings will enable them to have more knowledge of what is happening in bed allocation system. This study is considered important since it enriches our knowledge it is also hoped that this study will serve as a business for further research.

1.7 Definition of Terms

1. Patients:

The patient is a person whose is receiving medical treatment especially in hospital cancer patients. Patients is a person who receive treatment from particular doctor, dentists. Space spent our entire allocated for the year.

2. System:

Is an organized set of ideas or a particular way of doing something.

3. Record:

Is a written account of something that is kept so that it can be looked at and used in the future.

4. Field:

The field is the separated or distinct item of a data (part of a record).

5. Computerization:

The computerization is the conversion of a procedure or a process done manually to be automated processing .It is also the technology concerned with the application of mathematical, electrical and computer based system to operated system. G.U.I: There is an acronym for Graphic user interface. It is a term used by to windows operating system. It communicate with the action to the performed. You only point and click on the pictures (icons)to achieve them.

6. Software:

These are sets of instruction or program that are processed by the hardware, it is the part of the computer that cannot be touched but its action can be felt.

7. Bakura:

Is a local government area in Zamfara State, Nigeria. Its headquarters are in the town at Bakura at 12043’37”N 5052;23”E in the North-east of the local government Area. It has an area of 1,366km2 and a population of 186,905 at the population of 2006 census.

8. General Hospital:

General hospital that does not special in the treatment of a particular illness or patients of a particular sex or age group in essence is a hospital that provides a limited range of services (e.g orthopesic surgery, ophthalmology or obertetrics.

9. Zamfara state capital Gusau, 3,259,846 (2006 Census):

Motto; Farming is our pride. It is the state that was created by general Sani Abacha I 996 1st October. It has 14 LGAs which are Anka, Bakura, Bungudu, Birnin Magaji, Kaura Namoda, Maradun, Maru, Shinkafi, Talata Mafara, Tsafe and Zurmi. Its 12o10N-6015E/12.1670N 6.2500E, total Area 39’762’42 (15,352 Sqmi). Zamfara State I mainly populated by Hausa and Fulani people with some members of Gwari, Kamko, Dakkarawa, Busawa & Zambamarwa ethnic communities, others included the Igbo, Yoruba, Kanun, Nupe and Tv. Agriculture is the main occupation of the people of the state and the central source of the income. Irrigation is required for cereals and legumes hence its slogan “farming is our pride” and also home of Shari’a. Hausa is the official language of the state other main languages spoken in Zamfara are English, French, Fulfulde and Arabic. Minority of the population also speak languages like Yoruba and Igbo.

Chapter Five

Conclusion and Recommendation

5.1 Conclusion

From the ongoing research, a detailed has been carried out and its activities and operation fully understood study of the hospital bed space allocation computerization management system. As a result the problem preventing the smooth and efficient operation of computerized hospital bed space allocation management system where identified. Thus the need for something to be done to put these problems in place becomes paramount. A search for possible solution was carried out; the result of which I believe will bring out an improvement and increase in efficiency if properly implemented.

5.2 Recommendation

The bed space allocation system for registration information system is the dynamic and flexible database system that can be implemented with maximum performance, hence the following recommendation have been made, the bed space system information system record should be changed or improved to meet up with up to date user’s requirement, the hospital registration should be computerized to meet international standard and of curse speed up administrative process in the Corporate Farida hospital Gusau, the system should be implemented to facilitate easy and effectively registration of the hospital and availability checking exercise, which in turn improve the Importance and Functions.

It is recommended that the future researchers in this area should be able to look at the possibility of transforming this system into an computrizetion system. The improved system should be able to provide an system of any patients that are register to the hospital. The Farida hospital should be able to invite the hospital and then register patients after the visit the hospital.

Get Complete Project Material

5,000 5000

The Complete Material Will Be Sent to You in Just 2 Steps

Quick & Simple…

Step One Purchase

Make Payment (Through Transfer) of ₦5,000 to the Account Below

Zenith BankAcc No: 1225513212
Samphina Academy
Current Account

Or CLICK HERE To Pay With Debit Card

CLICK HERE To Purchase Material ($15)

Step Two Purchase

Send the Following Details on WhatsApp ( 08143831497) After Payment

  1. Payment Details

  2. TOPIC: Automated Hospital Bed Allocation System

The Complete Material Will Be Sent To You On WhatsApp After Receiving Your Details
T & C Apply

  Contact Our Help Desk

Need a Different Topic? Perform a Quick Search

List of Related Works

Click on Any Topic to Preview the Content

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.