DESIGN AND IMPLEMENTATION OF DATA MINING FOR MEDICAL RECORD SYSTEM

ABSTRACT

Data mining is the extraction of hidden predictive information from large database which helps in predicting future trend and behavior thereby helping management make knowledge driven decisions. The data mining tool designed is to aid in quick access and retrieval of patients information to avoid time wasted in retrieving of such data from hospitals data warehouse. The data mining tool was also designed to discover hidden pattern that helps in decision making by management. Structured System Analysis and Design Methodology were used in the analysis of the existing system which also provided a guide for the design of the proposed system.

PHP programming language and my SQL was used in the creation of a data warehouse for patient”Ÿs information and data mining tool for the retrieval of such information when needed.

CHAPTER ONE

Introduction

1.1 Background Of Study

Data mining, is the extraction of hidden predictive information from large database, is a powerful new technology with great potential to help companies focus on the most important information in their data warehouses. Data mining tools predict future trends and behaviors, allowing businesses to make proactive, knowledge driven decisions. The automated, prospective analysis offered by data mining move beyond the analyses of past events provided by retrospective tools typical of decision support systems. Data mining tools can answer business questions that traditionally were too time consuming to resolve. The scour databases for hidden patterns, finding predictive information those experts may miss because it lies outside their expectations.

Most companies already collect and refine massive quantities of data. Data mining techniques can be implemented rapidly on existing software and hardware platforms to enhance the value of existing information resources, and can be integrated with new products and system as they are brought on-line. Which implemented on high performance client/server or parallel processing computers, data mining tools can analyze massive database to deliver answers to questions such as “Which client are most likely to respond to my next promotional mailing, and Why?”

Data mining techniques are result of a long process research and product development. This evolution began when business data was first stored on computers, continued with improvement in data access, and more recently, generated technologies that allow users to navigate through their data in real time. Data mining takes this evolutionary process beyond retrospective data access and navigation to prospective and proactive information delivery.

Data mining is ready for application in the business community because it is supported by three technologies that are sufficiently mature: massive data collection, powerful multiprocessor computers and data mining algorithms. In this evolution from business data to business information, each new step has built upon the previous one. For example, dynamic data access is critical for drill-through in data navigation applications, and the ability to store large database is critical to data mining.

The file management is obsolete in developed countries like the United States where and in developing countries like Nigeria the file system is still processed manually in most medical centers; this is as a result of low standard of technology. It was clear that computer is everywhere in Nigeria. These computers are for money making and as a result of this, our hospitals lack computerized services, but with the help of data mining we can also computerize our hospitals.

1.2 Statement Of The Problem

The problem of data mining has become very crucial in areas of privacy of data. Specifically regarding the source of the data analyzed for certain purpose. My research in Owerri General Hospital here reveals that patients visit the hospital and they waste a lot of time. The patients waits for the nurses or the attendants to get their data and there are volumes of files to search through before the patients files is finally retrieved or the patients might forget his/her card when visit the hospital.

It there means that the patient”Ÿs data cannot be found due to the fact that the Nurse does not know the patients number. In this case it is either that the patients is denied treatment by the Doctor or the Nurses will check through the volumes of files in order to retrieved his/her data, this is time consuming problem. There is a problem of misplacing of patients data, the non-availability of relevant forms like x-ray/laboratory forms and chats (pressure chats temperature) and requirement of more workers to carry the folders into the consulting rooms as an evident.

Moreover, there are mistakes in entering patient”Ÿs records. Two patients might be given the same number and there could be wrong spelling and loss of important information. There is also lack of space for storing all the files and also due to carelessness on the part of staff.

Furthermore, volume of work for the hospital staff is much; this is because the ratio of patients to staff of Owerri General Hospital is so much. So staffs are over worked and they hurry through their duty, hence they carry out such duties lousily which makes the Doctors unfriendly to their patients.

1.3 Objective Of Study

Objectives of this research work are to:

Create a data warehouse for storage of patient”Ÿs information thereby eliminating manual file storage of patient”Ÿs records.

Design a good data mining tool that will help in easy retrieval of patient information thereby reducing time wastage and improve service delivery.

The data mining tool will be able to discover hidden pattern in large volume of data which will help in good decision making.

1.4 Significance Of Study

This research will cover the creation of good database system for the management of patient”Ÿs records in Owerri general hospital and also provide efficient data mining tool for easy retrieval of data and discovery of hidden patterns in large volume of data.

1.5 Scope Of Study

This research work will be carried out on data mining for medical record system of Owerri General Hospital. The work reported in this research could be viewed as a step towards enhancing databases with functionalities.

1.6 Limitation Of Study

Data mining record is limited in that; some manual operation will still be needed to carry out the operation effectively. There was some constraints encountered during collection of data, poor data collection becomes apparent due to interviewing of hospital representatives like the consultants. Nurses, Doctors, Hospital attendants who were reluctant to disclose important information and statistical data which otherwise would have been relevant to this research, due to hospital secret which breeds some indifferent attitudes towards that.

It takes a long time and large commitment of resources to get a good result, unavailability of text and materials on this topic, made gathering of facts very difficult, some of the facts were gathered from the internet, which is quite expensive.

1.7 Definition Of Terms

Data Mining:

Can be defined as “The nontrivial extraction of implicit, previously unknown, and potentially useful information from data, and “The science of extracting useful information from large data set or databases”.

It involves sorting through large amounts of data and picking out relevant information.

Information Retrieval:

The act of locating quantities of data stored in a Database and producing useful information from the data.

Information Processing:

A method of organizing, processing and extracting information to be easily stored, retrieved, searched and updated.

Record:

It is a unit of data representing a particular transaction or a basic element of a file consisting in turn a number of interrelated data elements.

Hospital:

A hospital is an institution of medical treatment of the sick and injured people.

Model:

Is a pattern or mathematical/symbolic representation of real life system and or abstract system behaviors.

Artificial Intelligence:

It is a branch of computer science that is dedicated to the study of the ways in which computers can be used to emulate or duplicate most human function.

Knowledge Base:

Is an organized collection of declarative and procedural relationships that represents expertise in a focused area

…

CHAPTER TWO

2.0 Literature Review

2.1 Introduction

The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …

Procedure for Downloading the PDF (Docx) Material

Design and Implementation of Data Mining for Medical Record System can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.

Seminar Material Cost
₦3,000

Project Material Cost
₦5,000

Request Complete Material

Complete Material Chapters of Design and Implementation of Data Mining for Medical Record System

Click here to request the Complete Material via WhatsApp including;

Preliminary Pages,
Chapter 1-5,
References and Appendix.

TABLE OF CONTENTS
PRELIMINARY PAGES

Title page
Approval page
Dedication
Acknowledgement
Table of Contents
Abstract

CHAPTER ONE

Introduction

1.1 Background of Study

1.2 Statement of the Problem

1.3 Objectives of Study

1.4 Significance of Study

1.5 Scope of Study

1.6 Limitations of Study

1.7 Definition of related terms

CHAPTER TWO

Review of Related Literature

2.1 Introduction

2.2 Review of related literature

CHAPTER THREE

System Analysis and Methodology

3.1 System analysis

3.2 Method of data collection

3.2.1 Interviewing key officer

3.2.2 Observation method

3.2.3 Examination of document

3.3 Analysis of the existing system

3.3.1 Organization profile chart

3.3.2 Advantages of the existing system

3.3.3 Disadvantage of the existing system

3.4 Analysis of the proposed system

3.4.1 Justification of the proposed system

3.5 Methodology

3.5.1 Recommended appropriate mode

CHAPTER FOUR

System Design and Implementation

4.1 Overview of design

4.2 Main menu

4.3 Program modules specification

4.3.1 Database design and specification

4.3.2 Input/output specification

4.3.3 Input form

4.3.4 Output form

4.3.4.1 Medical record system

4.4 Flowchart of the proposed solution

4.5 Choice and justification of programming language

4.6 System requirement

4.7 Implementation plan

4.7.1 Testing

4.7.2 Conversion

4.7.3 Training

4.8 Maintenance details

CHAPTER FIVE

Summary, Recommendations, Conclusion

5.1 Summary

5.2 Review of achievements

5.3 Areas of application

5.4 Suggestion for further studies

5.5 Recommendation

5.6 Conclusion

REFERENCES

APPENDIX A (Program codes)

APPENDIX B (Sample, output forms)

Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of Data Mining for Medical Record System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.

Frequently Asked Questions (FAQ)

Can this topic “An Assessment of the Effects of Processing Methods on the Physico-Chemical Properties of Sorghum and Sweet Potato” be used for Biochemistry Project?

Yes it can be utilized for research — This study evaluated “the effects of processing methods on the physicochemical properties of sweet potato and sorghum flour”. Sweet potato (Ipomoea batatas) is an important food crop in the tropical and sub-tropical countries and belongs to the family convolvulaceae. Sweet potatoes are rich in dietary fiber, minerals, vitamins, and antioxidants such as phenolic acids, anthocyanins, tocopherol and β-carotene. The proximate composition of sweet potato was determined and these include moisture, lipids, ash, protein, carbohydrates and fiber. In carrying out the analysis practically, methods used vary according to the food material. The antioxidants were also determined alongside with phenol oxidase, pasting properties, minerals and sweet potato contents. Sorghum is a tropical plant belonging to the family of poaceae. More than 35% …

Can the material for “Foreign Exchange and International Trade Its Effect on Bank Profitability” be used as a guide for Banking and Finance (BF) Project?

Yes it can be used — This project is titled foreign exchange and international trade it’s effect on bank profitability. It examines the extent and effect of foreign presence in domestic banking markets. It investigate how net interest margins, overhead tax paid and profitability differ between foreign and domestic banks we find that foreign banks have higher profit than domestic bank in developing countries but the opposite is the case for developed countries. Estimation result suggest that an increased presence of foreign bank is association with a reduction in profitability and margins for domestic banks are regard to foreign exchange and international trade. …

Can the material for “Effect of Leadership Style on Subordinate Productivity” be used as a guide for Industrial Relations and Personnel Management (IRPM) Project?

Yes it can be used — From the immemorial, the role of leaders in ensuring excellence organizational performance cannot be emphasized. The need for adequate motivation suitable working environment, compensations efficient communication between employers and employees are important to promoting excellent organization performance. Though studies on motivation and leadership role amongst employees are well studied in financial organization in developed countries, less could be said of in financial organization in developing countries like Nigerian. Therefore, it was important to evaluate leadership and organizational performance in financial intuitions in Nigeria. The evaluation was done through the use of questionnaires with questions tailored towards determining: the relationship between leadership and organizational performance, pattern of leadership and the extent of factors for worker’s low performance and leadership style affected labour …

Can the material for “E-commerce Online Shopping for Hairs Only (Human Hairs)” be used as a guide for Computer Science (CS) Project?

Yes it can be used — The electronic commerce environment has been widespread developed, which provides consumers with a convenient platform to search for information interact with retailers and purchase products online. The aim of the study is to design and implement an E-commerce Online Shopping for Hairs Only (Human Hairs). In achieving this aim, the following specific objectives were laid out to design software that will be used to purchase human hairs online by the interested personnel, update new human hairs products and other related items online, used to make series of human hairs shopping online by the several personnel and make purchases for desired item and To develop an automated system for Hairs Only (Human Hairs) online shopping. The motivation that led to the …

Can this topic “Impact of News Commentaries on Radio Listeners” be used for Public Administration (PA) Project?

Yes it can be utilized for research — The aim of this research project is to know the essence of radio commentaries and its impact on the listeners. The project stars with information which given insight into the historical back ground of news commentaries. It processed to examine the impact news commentaries creates to this listens and the distinguishing features. It then derives into detailed exposition of relevant literature formation of research question and hypothesis. The research question was formulated to properly address the problem on radio commentary in relation to its listens. Questionnaire were administered to the sampled respondents. The findings on the study reveled that news commentaries have less impact on some resident of the country as a result of low level of awareness and illiteracy. …

Can the material for “Design and Implementation of a Computer Based Payroll System” be used as a guide for Computer Science (CS) Project?

Yes it can be used — A payroll system is software which organizes and arranges all the tasks of employee payment and the filing of employee taxes. The aim of the study is to design and implement a Computer Based Payroll System that will eliminate the problems of the existing system. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will calculate the basic salary and allowance of staff, provide an easy way not only to automate all functionalities involved, and manage the leaves and Payroll for the employees of the Federal Polytechnic Nekede. The motivation that led to the implementation of the proposed system, is as a result of the difficulty in handling personnel records …

Can the material for “Production and Evaluation of Enriched Fried Unripe Plantain Cake” be used as a guide for Biochemistry Project?

Yes it can be used — The study evaluates the Production process of Enriched Fried Unripe Plantain Cake (Akara). In achieving this aim, the following specific objectives were laid out to evaluate the produced enriched fried unripe plantain cake, prepare cakes from plantain composite flour blends, analyze the quality characteristics of the produced plantain cakes this included the physical, chemical and sensory properties of the product and evaluate the composition of cake produced from different ratios of plantain. Nutrient composition, organoleptic attributes and overall acceptability of plantain cake were evaluated. Plantain fingers in stages 2 (URP) and 5 of ripeness (RP) used in this study were washed, peeled, sliced into small pieces, sun-dried for five days and milled separately into flour. All the fried unripe plantain …

Can the material for “Effect of Natural Soil Fertility on Lycopersicon Esculentum (Tomato)” be used as a guide for Agricultural Economics and Extension Project?

Yes it can be used — A naturally fertile soil is that which have been allowed to undergo varying physical, chemical and biological decomposition as a result of the activities of the various micro-organisms (protozoa, bacteria, viruses) on the leaves and other plants materials that had fallen on the soil for a very long period say twenty (20) to thirty (30) years. These materials are being eaten up by soil macro-fauna: earthworm, termites, ants and then subjected to decomposition by soil micro-flora: bacteria, viruses and actinomycetes thereby resulting in the mixing of the organic and mineral matter with both micro-flora and fauna playing vital roles and the net result is a naturally fertile soil. Soil natural fertility has a dominant role and influence on the growing of …

Can the material for “Problems of Financing Small – Scale Enterprises in Nigeria” be used as a guide for Banking and Finance (BF) Project?

Yes it can be used — This study is under taken to explore some of the problems often encountered by small scale industrialists in Nigeria with special reference to small scale enterprises in Nigeria. The study annually looked into the various firms of finance used by the small-scale business. This research work is so by the federal government to improve small scale enterprises in the country. This subject is discussed in five chapters. The first chapter among other things introduced the background of the study, statement of problems, the purpose, significant, limitations and the definition of terms. Chapter two is a review of various literatures related to the topic Chapter three discussed how research was carried out which present the researcher’s methodology. Chapter four discusses the findings. While chapter comprises the …

Can the material for “Audit Tenure and Quality of Financial Reporting in Nigeria” be used as a guide for Economics Project?

Yes it can be used — The purpose of this study is to examine the relationship between the tenure of auditor and audit quality in Nigeria. The Binary Logit Model estimation technique was use to analyze the relationship between the tenure of an auditor and audit quality. Further research should consider other vital variables that affect audit quality such as non-audit services. Findings reveal that there is a negative relationship between auditor tenure and audit quality though the variable was not significant.. The recommendation is that there is the need for the financial reporting council and other regulatory bodies in line with best practices to look critically into the issue of auditor tenure and its impact on audit quality in Nigeria. …