Rosina Surovi Khan et al. / (IJCSE) International Journal on Computer Science and Engineering Vol. 02, No. 08, 2010, 2616-2621 Design of a Hospital-Based Database System (A Case Study of BIRDEM) Rosina Surovi Khan Department of Computer Science and Engineering Ahsanullah University of Science and Technology (AUST) Dhaka, Bangladesh Email: surovi99@yahoo.com Mohammad Saber Department of Computer Science and Engineering Ahsanullah University of Science and Technology (AUST) Dhaka, Bangladesh Email: saber@aust.edu Abstract— As technology advances, information in different organizations of Bangladesh can no more be maintained manually. There is a growing need for the information to become computerized so that it can be suitably stored. This is where databases come into the picture. Databases are convenient storage systems which can store large amounts of data and together with application programs such as interfaces they can aid in faster retrieval of data. An initiative was taken to design a complete database system for a hospital management such as Bangladesh Institute of Research and rehabilitation in Diabetes, Endocrine and Metabolic disorders (BIRDEM) in Dhaka so that its information can be stored, maintained, updated and retrieved conveniently and efficiently. The existing information in BIRDEM is partly computerized via databases only in patients’ admissions, doctors’ appointments and medical tests and reports sections. A partly slow and tedious manual system still exists in BIRDEM for example, in record of ambulances in service, assigning ward boys and nurses to rooms, the billing process and record of doctors’ prescriptions etc. However, this paper outlines one complete database design for the entire BIRDEM hospital in which data maintenance and retrieval are in perfect harmony and speedy. Sample SQL-based queries executed on the designed system are also demonstrated. Keywords- Database system, entity relationship diagram, relational model, normalization, SQL-based queries. Introduction Bangladesh Institute of Research and rehabilitation in Diabetes, Endocrine and Metabolic disorders, abbreviated as BIRDEM, is a Research Center for Diabetes and also a hospital. There are doctors, patients, and employees like nurses, ward boys, ambulance carriers which are considered as entities in the designed system. It becomes a tough, tedious and comparatively slow process to store the information partly manually and partly computerized. But having all the necessary information stored in one database, it not only helps in orderly maintenance but very speedy retrieval of data. I. EXTRACTION OF INFORMATION FROM HOSPITAL MANAGEMENT (BIRDEM) BIRDEM was visited and information was gathered; demos were seen and its websites visited from the internet. Now Ibrahim Medical College is founded in BIRDEM for the MBBS degree. A lot of students pass MBBS from this medical college. [3,4] A database system was designed based on a case study of BIRDEM Hospital via Entity Relationship Diagram (ERD), Relational Model , Normalization of tables and Implementation in SQL server. [1,2,5] The ERD is outlined below. II. DATABASE DESIGN A. Entity Relationship Model (ERM) 1) ER Diagram In the ER diagram, we can view the entities- Patient, Doctor, Receptionist, Department, Medicine, Test, OT (Operation Theater), Room, Nurse, Ward_boy, Driver, Ambulance, Carriers, Accountant and Bill. Among these entities, relationships exist which connect all the entities in the diagram. For example, Patient, Doctor and Receptionist are connected via the relationship Appointment. In other words, a receptionist will set up a doctor’s appointment for a patient. Similarly, Doctor, Patient and Medicine are connected via the relationship Prescription. Here, a doctor may prescribe one or more medicine to a patient. In a similar way, other entities are connected via relationships in a meaningful way. Cardinality ratios [1] for the entities connected to a relationship are explained in the next section. 2) Cardinalities Binary Relationship We can see a binary relationship in the ER diagram. The work in this paper has been supervised by Rosina Surovi Khan for her student Syed Mahboob Nur and his group as a thesis work in Year 4, Semester 1, CSE, AUST in Fall 2009. ISSN : 0975-3397 2616