Health Informatics: Analyzing Digital Public Health Management System

This report provides a detailed analysis of a proposed digital public health management system, focusing on the types of information and data required, the reports users would need, and a feasibility assessment. It discusses the importance of data element definitions, relational models, and database development using SQL. The report also examines the skills required by experts, such as efficiency in database development, query designing, and data normalization. Furthermore, it explores the kinds of reports the system should generate, including scanned documents, blood reports, and medical history. The feasibility study concludes that the project is viable, emphasizing the benefits of a centralized database for efficient health record management while also acknowledging potential limitations, such as reliance on accurate patient data and challenges in interpreting complex reports like X-rays. The report assumes regular data updates and accurate lab results for optimal system performance. Desklib offers this and many other solved assignments for students.

Health Informatics

Contents
Question 1:.................................................................................................................................2
Answer 1.................................................................................................................................2
Question 2..................................................................................................................................3
Answer 2.................................................................................................................................3
Question 3..................................................................................................................................3
Answer 3.................................................................................................................................4
References:.................................................................................................................................4

Question 1:
Types of information or data required for the digital public health management system for
compilation and provide Evidences of data with examples.
Answer 1
The proposed system should focus on the analysis of the skills and expertise of the end user
i.e. patient, providing data element definition table, easy accessing of the data retrieval,
development of the relational model for defining relationship between different entities such
as doctors, patient, administrator, housekeeping staff, pharmacy, and others, development of
the database with SQL language, functionality for updating the required information of the
patient on the database, accessing of the database through the integration of network support,
functionality to perform normalization operation (Campbell, 2010).
The ranking of the skills is provided to the activities undertaken to analyse the efficiency of
the expert which is represented in the following table (Grohol, 2008):
Skill Ranking of the skill Sum of ranks on the basis of
skills
Efficiency in developing the
project on SQL
8 121
Determining the data element
used in the database
7 102
Analysis of the user
requirement
2 120
Effectiveness in performing
normalization function
6 132
Creativity and analysing
critical situation
7 67
Providing data quality 8 72
Efficiency of query designing 5 45
The above table shows that the expert should possess high level of skills in the development
of the database for the proposed project. The examination of the skills and expertise of the

expert helps in the deployment of creative thinking in performing the operation like
manipulation, modification, insertion, deletion, copying, editing, updating, and others in the
database table.
Question 2
What Kind of reports would the user of the proposed system like to be able to generate
Answer 2
The proposed system on electronic health record system helps in managing the reports
associated with the health and medical report of the patient. The database of the proposed
system helps in managing the electronic health records of the patient efficiently in the
database. The handling of the required information can be easily done with the retrieval of the
information from the database on demand of the user (Ryan and Thompson, 2015). The types
of reports which are stored on the electronic database are scanned document of the patient
based on previous prescription, blood reports of the patient, medical information, family
background, and other required clinical documentation. The patients have to manage his
account on the application software of the electronic health system. The successful
registration of the patient will asked to provide photographs of the disease affected area,
medical reports of the past prescription, appointment with the required doctor on the basis of
specialization, family background detail in case of emergency contact, and others (Benc,
2010). The updating function helps in uploading new scanned prescription of the patient
according to the requirement. The retrieval of acknowledgement from the doctor side helps in
notifying the patient that his case is under consideration. The clinical note from the doctor’s
end will be provided on the user profile to get treatment instantaneously (Bellika, Henriksen,
Hurley, Budrionis, Marco, Yigzaw, and Hailemichael, 2017). The database of the proposed
system helps in managing the electronic health records of the patient efficiently in the
database in the effective and efficient manner.
Question 3
What is the feasibility report of the proposed project? Do you think that the proposal is
feasible or not? What possible problems or barrier do you foresee? What are the assumptions
made?

Answer 3
The feasibility report helps in measuring the quality of the outcome which is going to be
produced at the completion of the project.
Yes, the proposed project is feasible because the management of the central database helps in
managing sufficient information related to the patient health record for getting high quality
treatment from the experts. The required information of the patient can be fetched by the
experts within a fraction of second in the synchronized order. The development of the
electronic health record system helps in resolving various issues equipped with the
complexity in handling of health report in the synchronised order and fetching of relevant
record from the pool of report, no flexibility in updating the data, and time consuming
process.
The deployment of the feasibility process helps in emphasising on the limitation and gaps
which exist with the proposed project. There are some limitations with the proposed project
such as if the patient does not update his profile data than the wrong treatment can be
prescribed by the expert on the basis of his older reports. The expert can face complexity in
reading the x-ray report of the project (Nisar and Said, 2008). The effective working of the
project is based on some assumptions such as relevant data is provided by the patient for
check-up, the reports updated by the patient is drawn from the lab, regular updating of the
information on the portal on the basis of improvement, and other.
References:
Bellika, G, Henriksen, T, Hurley, J, Budrionis, A, Marco, L, Yigzaw, K, and Hailemichael,
M. (2017). Electronic health record data reuse infrastructure requirement. Retrieved
from https://ehealthresearch.no/files/documents/Prosjektrapporter/NSE-rapport_2017-
10_EHR_data_reuse_infrastructure_requirements.pdf
Benc, I. (2010). A feasibility study for the integration of a remote patient monitoring solution
with electronic health record system. Retrieved from
https://www.researchgate.net/publication/224162840_A_feasibility_study_for_the_int
egration_of_a_remote_patient_monitoring_solution_with_electronic_health_record_s
ystem

Campbell, R. (2010). Database design: What HIM professionals need to know. Retrieved
from http://bok.ahima.org/doc?oid=58128#.WsOL4YhubIU
Grohol, J. (2008). Using aggregate data to help public health. Retrieved from
https://participatorymedicine.org/epatients/2008/11/using-aggregate-data-to-help-
public-health.html
Nisar, S. and Said, A. (2011). Proposed framework for electronic clinical record information
system. International journal on computational sciences and application, 1(1).
Retrieved http://wireilla.com/papers/ijcsa/V1N1/1211ijcsa02.pdf
Ryan, A. and Thompson, C. (2015). The use of aggregate data for measuring practice
improvement. Retrieved from https://www.ncbi.nlm.nih.gov/pubmed/12092272