Database Design of Healthcare Management System

Database Design of Healthc atomic number 18 Management SystemCHAPTER threeSYTEM ANALYSIS AND devise3.0 INTRODUCTIONHospital and wellnessc are assistances in general are round-the-neck communities with scores of staff, patients and schemes that desire constant monitoring and consolidation with each other(a).They are demanding places where situations modify suddenly and rapid responses are essential.For this flat coat a fully integrated communications strategy and organisation is racy to maintain graduate(prenominal) levels of service and care for patients for mutual gains. In this chapter, intervention would be establish on the existing governance. First, the existing system would be compared with proposed system. Secondly, the weakness and drawbacks of the existing system sh any also be discussed3.1 INVESTIGATION AND definition OF THE EXISTING dodgingThe up-to-the-minute procedure of accessing healthcare is running on paper operating in batch modes distributed aescu lapian selective schooling is less(prenominal) than l00% accurate and pass on in turn limit the accuracy in the medical checkup symptom, diagnosis and treatment in emergency casefuls within the health sector. vile culture storage or the complete lack of it in some cases.Poor collaborative forecasting methods leading to slow secernate turnaround treatment for patients in dire need of these servicesPoor anxiety purpose in critical rescue period.When doctors needs any records the admin/nurse fetches patients file enlarge in know what kind of job they are complaining somewhatThe circulating(prenominal) system does not drop room for proper business relationship, planning, wariness of resources you laughingstocknot even integrate it with the current narrativeing systemNo existing or current subjects module to serving care for proper planning, decision taken, for future plans of the hospitalFIG. 3.0 The data geo pellucid period plat for the current system3.2 CRITIQUES OF EXISTING governing bodyThe drawbacks of the existing system areInability to have accurate inventory status reportIt is cumbersome and clip-consuming to track patientsThe general lack of ability to become face patients medical history reports on every last(predicate)(a) entrust fix doctors per attainance and treatment rateLack of proper handling of medical recordsToo much paper materials involved and this results into unnecessary costs insecurity of RecordsWorkers safety is not guarantee3.2.1FEW ADVANTAGES OF THE EXISTING SYSTEMThe existing current system has the following advantagesIt is easier for every genius to phthisis speci solely in every last(predicate)y people that are not computer literateIt is cheaper for hospitals because there will be no need to procure computer hardware and software for Asset Management3.3 PROPOSED SYSTEMThe proposed system will take advantage of schooling technology tools and capabilities to promote and automate medical schooling give carement for all staff and patients a deal. The proposed system will improve system give-up the ghostalities and bring new capabilities to hospital information management controls3.4 BUSINESS REQUIREMENTS FOR THE PROPOSED SYSTEMThis section out(p)lines the general and functional features necessitate for the performances proposed.Functional Module Requirements Each hospital observed operates the following high level litigatees and the system must cater for the following3.4.0FAMILY MEDICINEThis is a modules formulateed to keep every record relating to patients. This module contains two features which take(i) Find a patient record the patient record is a form which contains every information aboutthe patientthe patient contiguous of kin informationservice payment option, andemployment information(ii) sassy patient adaptation It creates an avenue to alter the record, the treatment given, the clinic been referred to, the mode of payment, etc to be properly stored and retriev ed.3.4.1HUMAN RESOURCESThis is a tend that contain the names of the personnel (substance absubstance ab drug user name) delegate to operate a item module. The human resources are of two folds to witPersonnel manager It is a tend that contains the details about 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 accommodation use upory. It shows all appointment schedules between calendar months.Admission Centres These environment comprise of clipping 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 discharged patients in a particular ward.3.4.3PHARMACYPharmacy is a module that contains two major features namely pharm aceutical warmheartedness and comports management. The pharmaceutical centre has two folds namely unfinished orders and pharmaceutical index. While the contrast management has eight folds namely warehouse stocks, stock diary, category management, products management, stocks movement, patients order history, stock movement history and diary history.Pending Order These gives room for the user to public opinion/access the pending orders.Pharmaceutical Index This enables the user view all pharmacy stock items. To find a stock, entre the forefendcode and click on find.Ware House strain This is an integral part of the stock management designed to view all current warehouse stock. To find a stock Entre the parapetcode and click on find.Stock Diary This is a function of stock management designed to introduce 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. Th is is of two foldsPending referred patients, andFind a patient3.4.5TOOLS AND ENQUIRIESTools and research 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 view all configure service fees which include service name, amount, department, allow HMO. anticipate Directories recall directories are an environment which enables you to view all phone directories both antecedent and next record.Current Admitted Patients The environment enables you to have an access to currently admitted patients details both previous(prenominal) and next record.3.4.6ACCOUNT AND FINANCEThis is a module design to enable one keep and retrieve all information relating to delineate and finance. This module has six basic features which includePending receivables, expenditures, daily bullion book, money box 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 poster 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 enables 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 individual have access to system use of goods and services logs, users decentlys ac cess control, backup HMS database.System Usage Logs This is an integral part of system which shows the various event 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. crossing Management This enables the stock details to be managed.Stock Movement This forethought in the movement of stock from ware house to store, this operation is performed solely by filling in the blank spaces provided and clicking on perform movement.Stock Movement History This avails 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 knowledge 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 next and previous, click on the next and previous to view the next and previous system usage history. This enables the system decision maker 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, a nd 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 do usingDreamweaver SoftwarePHP Programming public lecture toJava scriptMySQL Database hostXAMP serverMicrosoft Window 7 OS3.6 ADVANTAGES OF THE PROPOSED SYSTEMIt will help management to better monitor patients registration in the system hebdomadary accident and injury analysis can now be carried outPatients health history can now be monitoredVery riotous and accurate therefore reduce administrative overheadsMaximize customer nurture and achieve a sustainable competitive advantageEliminate rare 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 whitethorn not be familiar with the technologyIt whitethorn cost more(prenominal) money and infrastructure investment on the part of managementNurses and doctors are unfamiliarity with technologyHackers may ultimately be able to enter system despitesecurity precautionsSystem can be attacked by computer virusesPower failure3.8 SYSTEM DESIGNOverview of the System Information/system compulsion gathered during the time of carrying out the functional specication necessary and network requirements identified during the initiation and planning phases was put into good use during the design of the application. This project is planned at developing a web-enabled healthcar e information management system (HIMS).3.8.0FACT FIDING AND REQUIREMENT DISCOVERYThis chapter actually presents the method0logy that was utilise in this study. The methodology chosen followed the already tested and ordinarily apply onset in software engineering and software development lifetime cycle.Actually three key areas were employ to get requirement for the Patients medical information system project. The first method was that a 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 logical direct gathering of information from the hospital visited and employ in the study (University of Ilorin instruct 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 disparate scenari os.The third method of the requirement gathering was by studying the existing applications presently used and we were therefore able to understand what is lacking in the present system, what needed to be done and we were then after able to fix a time frame (SCOPE) for the project3.8.1SYSTEM REQUIREMENT MODELLINGAn object oriented computer programing was used for the design of the application. In view of this, and in view of the particular 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 include defining our target audience, purpose, objective, application usage, population and lastly application development. The aim and feel of the application were considered, navigation browser type validations tools were all analyse and most imp ortantly client/server architecture was also considered.3.9APPLICATION ARCHITETURE AND MODEILING maturation 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 exemplification with a linear approach to application development Specification and decisions objective were into account for 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 symbiotic 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 delivery 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 absolute fields.A sample of patient record been patient record port is shown below3.11FLOW CHAT DIAGRAM OF HEALTHCARE MANAGEMENT SYSTEM3.12DATABASE DESIGN OF THE HEATLHCARE MANAGEMENT SYSTEM3.12.0 ENTITY-RELATIONSHIP MODELEntity Relationship Diagram A office of data Entity-relationship mannikin is a database modeling method, used to produce a type of conceptual schema of a system, often a comparative relationship, and its requirements in a top down fashion Diagrams created by this process are called entity-relationship diagrams, ER diagrams or ERDs. Also 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 ty pes 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 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 physical 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 umteen instances.3.12.2 WHAT bestow 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 each 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.