Database Design of Healthcare Management System

entropybase Design of Healthcare perplexity SystemCHAPTER THREESYTEM ANALYSIS AND DESIGN3.0 INTRODUCTION hospital and healthcare work in general are round-the-neck communities with scores of staff, patients and remainss that take on constant monitoring and integration with each other.They are demanding places where situations change suddenly and rapid responses are essential.For this basis a fully integ ordaind communications strategy and brass is vital to maintain high butts of process and care for patients for mutual gains. In this chapter, discussion would be based on the existing system. First, the existing system would be compared with proposed system. Secondly, the weakness and drawbacks of the existing system sh completely also be discussed3.1 INVESTIGATION AND DESCRIPTION OF THE breathing trunkThe current procedure of accessing healthcare is running on paper operating in batch modes distributed medical data is less than l00% accurate and will in turn limit the acc uracy in the medical symptom, diagnosis and treatment in emergency cases within the health sector.Poor training storage or the complete lack of it in some cases.Poor collaborative forecasting methods leading to slow order turnaround treatment for patients in dire need of these inspection and repairsPoor screwment decision in critical rescue period.When doctors needs any records the admin/nurse fetches patients file in gradient tuition in know what variant of problem they are complaining aboutThe current system does not give room for proper news report, planning, management of resources you cannot even integrate it with the current accounting systemNo existing or current reports module to help management for proper planning, decision taken, for future plans of the infirmaryFIG. 3.0 The data flow plot for the current system3.2 CRITIQUES OF EXISTING brassThe drawbacks of the existing system areInability to form accurate inventory status reportIt is cumbersome and time-consumin g to track patientsThe general lack of ability to generate instance patients medical history reports on all(prenominal) will affect doctors performance and treatment rateLack of proper handling of medical recordsToo much paper materials involved and this results into unnecessary costsInsecurity of RecordsWorkers safety is not guarantee3.2.1FEW ADVANTAGES OF THE EXISTING SYSTEMThe existing current system has the following advantagesIt is easier for everyone to use specially people that are not computer literateIt is cheaper for hospitals because there will be no need to procure computer hardware and software product for Asset Management3.3 PROPOSED SYSTEMThe proposed system will take advantage of data engine room tools and capabilities to enhance and automate medical information management for all staff and patients alike. The proposed system will improve system functionalities and bring new capabilities to hospital information management controls3.4 BUSINESS exigencyS FOR THE PR OPOSED SYSTEMThis section outlines the general and functional features mandatory for the operations proposed.Functional Module Requirements Each hospital observed operates the following high level processes and the system must cater for the following3.4.0FAMILY MEDICINEThis is a modules send offed to encumber every record relating to patients. This module delays two features which include(i) Find a patient record the patient record is a form which contains every information aboutthe patientthe patient next of kin informationservice payment option, andemployment information(ii) New patient adaption It creates an avenue to enable the record, the treatment given, the clinic been referred to, the mode of payment, etc to be properly stored and retrieved.3.4.1HUMAN RESOURCESThis is a list that contain the names of the personnel ( exploiter name) assigned to operate a specific module. The human resources are of two folds namelyPersonnel manager It is a list that contains the details a bout the management Staff of various departments.Recruit new personnel this is a form that ensures that newly recruited personnel information is been stored.3.4.2SCHEDULEThe schedule describes the appointment directory. It shows all appointment schedules amongst calendar months.Admission Centres These environs comprise of time lag listWard, Ward occupancy and bedNurses listReport and historyWaiting List It shows the list of patients to be admitted to various wards.Nurses List It is a list that shows the details of the nurses staff and their department.Report and History It is a list that shows all carry out patients in a particular ward.3.4.3PHARMACYPharmacy is a module that contains two major features namely pharmaceutical centre and line of merchandises management. The pharmaceutical centre has two folds namely pending orders and pharmaceutical index. While the stock management has eight folds namely storage waremenage stocks, stock diary, category management, products manag ement, stocks grounds, patients order history, stock movement history and diary history.Pending Order These gives room for the user to post/access the pending orders.Pharmaceutical Index This enables the user view all pharmacy stock items. To relegate a stock, entre the obturatecode and click on find.Ware House Stock This is an integral part of the stock management designed to view all current warehouse stock. To find a stock Entre the barcode and click on find.Stock Diary This is a function of stock management designed to enter the new stock diary. To enter the new stock diary3.4.4SPECIALTY CLINICThis is a module that gives information about the various clinics and the patients been referred there. This is of two foldsPending referred patients, andFind a patient3.4.5TOOLS AND ENQUIRIESTools and doubt is a module that ensures an access to view service fees, telephone directory, and current admitted patients.Service Fees Environment view service fees environment enables you to v iew all tack service fees which include service name, amount, department, allow HMO.Telephone Directories Telephone directories are an environment which enables you to view all phone directories both previous and next record. legitimate Admitted Patients The environment enables you to have an access to currently admitted patients details both previous and next record.3.4.6ACCOUNT AND FINANCEThis is a module design to enable one keep and retrieve all information relating to account and finance. This module has six basic features which includePending receivables, expenditures, daily cash book, bank account, service fees, reportsPending Receivables This is an environment that enables you to have an access to pending service fee payments. An environment will be displayed in which the menu bar at the left hand side of the page headed account/ financial mode contains six departments namely pending receivables, expenditure, daily cashbook, bank accounts, services fees and reports.This ena bles a user to view and receive pending service payment.Expenditure It enables users to record new expenditure.Daily Cash Book It enables user to post cashbook for all department.Bank Account It enable user to manage bank account. It shows all banks and balance details. It also creates a room for the addition of a new bank account.Service Fees It enables user to view all service fees/chargesReport It enable user to view financial reports such as the receivable reports, expenses reports and cashbook reports between calendar months.3.4.7SYSTEMThis is an environment designed to enable an singular have access to system usage lumbers, users rights access control, backup HMS database.System Usage Logs This is an integral part of system which shows the various cause date, event performed, user IP address, event time and department accessed.Users Rights And Access Control This is an environment designed to show all system users account.Category Management This enables the user to manage stock category.Product Management This enables the stock details to be managed.Stock Movement This aid in the movement of stock from ware house to store, this operation is performed simply by filling in the blank spaces provided and clicking on perform movement.Stock Movement History This helps to view all stock movement history. it shows stock / item name, batch ID, units moved, the date and notes.Dairy History This helps to view all stock dairy history.My Account Information This is a menu bar located at the left hand side and it is accessible in every module. It comprises of waiting list appointment, my usage / access logs, personal data, change password, and log out from HMS.My Waiting List/ Appointment this is a waiting list designed to view all appointments and schedules.My Usage/ Access Logs this enables one to view all system usage history. Click on usage / access logs at the left hand side of the menu bar to view all system usage history. At the top right hand corner is n ext and previous, click on the next and previous to view the next and previous system usage history. This enables the system administrator to have an overview of the various event date, the event performer, event performed, the user IP address, the event time and the department accessed.3.4.8PERSONAL DATAThis enables an individual to view and update his personal information such as Name, DoB/Age, Gender, Hospital/Clinic Registration Number, Occupation, Addresses, Telephone Number, Stage of Origin, Religion, Next of Kin information and Date.Patient Bio Data A form which contains the information of the patient, next of kin information, and employment information will be displayed.Medical Record As the name implies, it deals with the patients medical history.3.5START-OFF THE PROJECTThe project implantation will be done usingDreamweaver SoftwarePHP Programming nomenclatureJava scriptMySQL Database waiterXAMP serverMicrosoft Window 7 OS3.6 ADVANTAGES OF THE PROPOSED SYSTEMIt will help management to better monitor patients registration in the systemPeriodic accident and reproach analysis can now be carried outPatients health history can now be monitoredVery fast and accurate therefore get administrative overheadsMaximize customer value and achieve a sustainable competitive advantageEliminate obsolete business processesSpeed up hospital production and responsiveness to incidentsIt will facilitates treatment of patients as patients history can now easily be retrieved from the systemBecause it is web based patients last update medical information csn be retrieved even if the patient goes to another hospital.It will give the doctors options of referring patients to other doctors completely automatedIt will allow hospital Management can plan better and make accurate and informed decisions3.7 DISADVANTAGE OF THE PROPOSED SYSTEMIt will lead to unemploymentIts only good for those that are computer literates, Nurses and doctors may not be familiar with the technologyIt may cost more money and infrastructure investment on the part of managementNurses and doctors are foreignness with technologyHackers may ultimately be able to penetrate system despitesecurity precautionsSystem can be attacked by computer viruses magnate failure3.8 SYSTEM DESIGNOverview of the System Information/system requirement gathered during the time of carrying out the functional specication requirement and network requirements identified during the creative activity and planning phases was put into good use during the design of the application. This project is planned at developing a web-enabled Healthcare information management system (HIMS).3.8.0FACT FIDING AND REQUIREMENT DISCOVERYThis chapter actually presents the method0logy that was used in this study. The methodology chosen followed the already tested and commonly used approach in software engineering and software development life cycle.Actually three key areas were used to get requirement for the Patients medical inf ormation system project. The first method was that a limited review of internet materials related to patient were carried out, I also tried to review specific platform of related design project to ascertain the specific language/platform to use for development of the application. The second most limpid direct gathering of information from the hospital visited and used in the study (University of Ilorin Teaching Hospital (UITH)). It must be quickly pointed out that the tools used in this case were interviewing of staff, observations of passive ways of these things and simulations of different scenarios.The third method of the requirement gathering was by studying the existing applications presently used and we were then able to understand what is lacking in the present system, what needed to be done and we were then by and by able to fix a time frame (SCOPE) for the project3.8.1SYSTEM REQUIREMENT MODELLINGAn object oriented programming was used for the design of the application. I n view of this, and in view of the fact that I intend to design an application that will be user friendly and easily accessible. I feel a web enabled application will be more appropriate since we are not talking of a windows application that will just be installed on a client machine in the office. We therefore focused on planning, which included defining our target audience, purpose, objective, application usage, population and finally application development. The go through and feel of the application were considered, navigation browser type validations tools were all analyzed and most importantly client/server architecture was also considered.3.9APPLICATION ARCHITETURE AND MODEILINGDeveloping a web application requires locus and determined effort on the part of the practitioner in meeting people needs The decision for accomplishing this was based on components based model with a linear approach to application development Specification and decisions objective were into account fo r example issues like meeting the applications purpose and aim and functionalities. The steps used here acted as an overall development methodology and life cycle which were also dependent upon available tools, time line, and user willingness to be involved in the final testing of the system. Implicit in the methodology adapted was the concept of bringing the Patients medical information system refining the application/system based on user feedback3.10 DESIGNS INPUTThe registration form be was designed as such that it will include all information required about the patients. The following is incorporated into the formImportant fields These are fields that must be filled because they are necessary information need.Return dialog box- This is used to guide against the input of wrong data or format in some fields especially the compulsory fields.A sample of patient record been patient record interface is shown below3.11FLOW CHAT DIAGRAM OF HEALTHCARE MANAGEMENT SYSTEM3.12DATABASE DESIG N OF THE HEATLHCARE MANAGEMENT SYSTEM3.12.0 ENTITY-RELATIONSHIP MODELEntity Relationship Diagram A nominateation of data Entity-relationship theoretical account is a database modeling method, used to produce a type of conceptual schema of a system, often a relational relationship, and its requirements in a top down fashion Diagrams created by this process are called entity-relationship diagrams, ER diagrams or ERDs. likewise it can also be defined as a specialized graphic that illustrates the interrelationships between entities in a database ER diagrams often use symbols to represent three different types of information.Boxes re commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes.3.12.1OVERVIEWAccording to subgenus Chen (Wikipedia), information system design uses these models during the requirements analysis to describe information needs or the type of information that is to be tored in a database. The data modeling technique can be used to describe any ontology (i.e. an overview and classifications of used terms and their relationships) for a a certain area of interest. In the case of the design of an information system that is based on a database, the conceptual data model is, at a later stage (usually called logical design), mapped to a logical data model, such as the relational model this in turn is mapped to a bodily model during physical design. An entity may be a physical object such as a customer transaction or order. Although the term entity is the one most commonly used, following Chen, we should really distinguish between an entity and entity-type. An entity-type is a category. An entity, strictly speaking, is an instance of a given entity-type. There are usually many a(prenominal) instances.3.12.2 WHAT LEAD TO ER DIAGRAMOnce the data has been created in the database the ER diagram will show the relationship between each table created they all have to link to eac h other. It could be one to many relationship, many to many or one to one relationship, there is always a unique field in the system and in this case it is the patients registration number identifying the patients anywhere in the system. We can retrieve the patients records once this registration number generated during registration is known.