Database Design for health Care System
Abstract
If there is one universal need, it is that everyone wishes for good healthcare system and facilities. And healthcare is undeniably a large industry, consuming a significant part of the national gross of many countriesso there are many valid reasons—all of them good ones—to pay attention to any procedure or methodology that can improve healthcare. But for all the good intentions, performing information processing in healthcare has been problematic, and there are many challenges when processing information related to healthcare sector came into account with doctors and health practitioners.So there is a need of a system through which accurate and better decisions can be made for patients and their lie risks can be minimized,these all reasons lead us to develop a healthcare system with anomaly free database design for accuracy.
Introduction
Almost every industry today is grappling with the challenge of IT issues surrounding with the huge expanding volume of data, there arenumerous databases and applications that use data, as well as the guidelines governing how that data is being shared. But the healthcare and clinical industry faces anexceptional set of challenges in modernizing its setup. Healthcare IT executives are being overburdened with developing and operating multiple solutions that integrate data from a range of, clinical, patient and back office systems to healthcare providers, patients, payers, technology and pharmaceutical companies.
These all needs including better decisions making for patients, online information transference to the doctor in case of emergency,updated and error free records of patients, huge number of transactionsand much more forces the organizations to develop the health care system.
Hence these IT based automated health care systems provides improved clinical decision making, better information management, better communication, minimize overall costs, and gives access to care. Hence for designing the better health care system there are multiple factors that needs to be considered but database design is the basic factor that needs to be error free and accurate in order to get the accurate data for patients in any transaction.
Right and error free data is very important for the life of any patient so medical database design is an extremely sensitive task that must be performed with great care by database designers.The field of critical care medicine could be advanced substantially by the development of comprehensive and accurate databases.Hence healthcare databases have been a vital component of understanding and improving critical care worldwide so main purpose of health care system also lies within the design of accurate database with less anomalies and redundancies.
Hence we will consider the healthcare system that is based on the records of the patients and operated by doctors. Hence this system has the database that contains two basic tables of doctors and patients and hence shows the relationship between these two entities. Hence it will be the relational database model based on following terms
- Tables
- Entities
- Relationships (one to one,one to many)
- Primary keys
- Foreign Keys
Solution
In order to make any system fool proof its database design must be error free.Hence medical care databases system should also have these designed features.
There must be noduplicate information (also called redundant data) related to the patient records, because it wastes space and increases the likelihood of errors and inconsistencies.
The second rule is that the correctness and completeness of information.Each information related to the patient their illness and their symptoms must be correct and updated so that lie risk foe every patient can be minimized.
Hence design process must comprised of following features so that errors can be minimized
Determine the purpose of your database
Hence it is important to know that for which purpose database is being designed.Hence In our case we will design database for the doctors so that they can access accurate and quick information related to the patient and hence can also update, add and delete the information related to the patients.
Organizing the required information
Hence it is very vital to organize properly the information.Hence in our case we have to organize the information from the prescription of patient.So information must be organized properly when added from paper to the database in the computer.
Converting information into tables
Hence the information we have extracted from the prescriptions have to convert into the form of tables.Hence at this point the major entities of the system are recognized.These entities are
- Patients
- Doctors
- Disease
And many more that can be taken into account or the perfect database design.
Converting information items into columns
Hence to determine the columns in a table, it must be decided what information you need to track about the subject recorded in the table.Hence for patient you must have certain information including patient no,patient DOB,patient address etc. Once you have determined the initial set of columns for each table these columns can be refined further.
Resources
- CPU processing power
- CPU architecture basics
- Client server architecture
- Non uniform memory access
- Operating system choices
- Storage reliability and RAID
- Database management system
Whole database design process has a fee of $2000 dollars.
Users
In our case the users of the database are doctors and hence they need trainingfor using the system. Hence in order to use the system with ease they must know the sensitivity of the patient’srecords.Doctors are although somehow aware of patient’ssensitivity so they do not need much training.