GCU Clinical Information from Fragmented Sources Project

User Generated

unonan123

Writing

Grand Canyon University

Description

The purpose of this assignment is to build upon your database project proposal in creating the database schema components. A schema is a logical grouping of database objects, such as tables, indexes, views, and queries that are related to each other.

To complete Part 2 of the Database Project Proposal assignment, write a 750-1,000 word essay that contains the following information:

  1. Restate your database project; describe its goal and objectives.
  2. Describe the purpose of the database schema for your project.
  3. Write out the process associated with your business rules relating to your database.
  4. Create a data dictionary that contains no less than five entities. Select and design an entity-relationship diagram (Crow, Chen, UML); Note: There are a variety of ER modeling software programs on the market. Microsoft Visio, OmniGraffle, LucidChart, and MySQL are few of these programs that will give free trials to create entity-relationship diagrams. In addition, you can simply create diagrams by utilizing Microsoft Word, PowerPoint Shapes, or SmartArt.
  5. Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling.
  6. Discuss the project's limitations and possible extensions.

Unformatted Attachment Preview

1 Running head: DATABASE PROJECT PROPOSAL Database Project Proposal Wendy Fernandez Grand Canyon University HIM - 650 (topic 2) August 2021 2 DATABASE PROJECT PROPOSAL Database Project Proposal Statement of the Problem Health quality measures are parameters used to evaluate the effectiveness and efficiency of healthcare organizations. Clinical data on parameters, such as structures and processes in healthcare organizations, are collected and then used to measure the extent to which the organization is capable of providing high quality healthcare services to a target population (Agency for Healthcare Research and Quality, 2015). Effective quality measurement is hindered by the lack of sufficient access to reliable clinical data. As noted by Grossmann (2010), the majority of the sources of clinical data are fragmented, and unconnected, making them inaccessible to the entities responsible for quality measurement. Even for the few accessible sources, stakeholders still face difficulties in compiling race and ethnicity data into their database for effective quality measurement. System-level difficulties and the discomfort associated with asking for racial data, for instance, hinder the bodies carrying out quality measurement activities from incorporating this vital data into their database (Agency for Healthcare Research and Quality, 2018b). Concerns about data security also discourage the development and use of a common database for compiling and reporting data for health quality measurements. The problem for this design project, therefore, is how to design a single secure and interoperable database that can be used to collect, and report reliable clinical information for quality measurement. Database Users 3 DATABASE PROJECT PROPOSAL System analysts and hospital staff would be the main users of the proposed database. System analysts would need to access the database, study it, and carry out maintenance activities. They have a background in computer science. They also have excellent analytical and communication skills. The staff comprises of nurses and administrators. They have basic training in information and communication technology. Data Types Database users would collect two types of data, that is, patient survey data and administrative data. Patient survey data implies self-reported information about patient’s experiences with, and perceptions about, healthcare services they have consumed (Agency for Healthcare Research and Quality, 2018a). This would be used to evaluate the processes and impacts of the healthcare organization. Administrative data are collected by a hospital’s staff in the course of service delivery. These may include elements such as types of services offered, amount of money paid, as well as the units of services consumed. The data entered into the database would be analyzed so as to produce structure reports, process reports, and outcome reports. Structure measurement reports would contain information about the availability of systems and capacity for effective delivery of healthcare services (Agency for Healthcare Research and Quality, 2015). Top-level managers in the organization would use this type of report to make decisions about how to improve existing systems and structures. Process reports would contain information about the measures taken to provide high-quality services (Agency for Healthcare Research and Quality, 2015). State health departments and the organizational managers would use recommendations in the report to improve the efficiency and effectiveness of healthcare services. Lastly, the outcome report would contain information relating 4 DATABASE PROJECT PROPOSAL to the perceptions and experiences of patients. Community members would use this information to guide their decisions when choosing their preferred healthcare providers. Goals and Objectives The goal of the project is to create a single secure database that compiles and stores clinical information from fragmented sources. The first objective is to create a secure database that guarantees patient privacy. The second objective is to ensure that the database is user-friendly such that users feel comfortable when soliciting different kinds of data. Third, the database must have the quality of internal and external interoperability. To ensure the database is secure and userfriendly, I would perform a thorough requirement analysis. I would also involve potential users in making design decisions. I would use an iterative process of prototyping to ensure that the final product is user-friendly, secure, and interoperable. Potential Barriers Social and legal aspects of data security might hinder me from achieving the project’s goal. The assumption is that users would volunteer their information to be used when developing and testing the database. Grossmann (2010) noted, however, that data security policies always limit the extent to which data can be used in database development projects. Resource constraint is the other problem that might hinder me from achieving the project objectives. Conclusion This project is important because it seeks to improve the efficiency and effectiveness of health quality assurance. The database would produce useful reports for improving healthcare organizations. The project is technically feasible since it would make use of existing technologies 5 DATABASE PROJECT PROPOSAL for data security and data interoperability. To ensure it is economically feasible, possibilities for partnerships and sponsorships would be explored. 6 DATABASE PROJECT PROPOSAL References Agency for Healthcare Research and Quality. (2018a). Data Sources for Health Care Quality Measures. Retrieved from https://www.ahrq.gov/talkingquality/measures/understand/index.html Agency for Healthcare Research and Quality. (2018b). Improving Data Collection across the Health Care System. Rockville, M. D. Retrieved from https://www.ahrq.gov/research/findings/final-reports/iomracereport/reldata5.html Agency for Healthcare Research and Quality. (2015). Types of Health Care Quality Measures. Retrieved from https://www.ahrq.gov/talkingquality/measures/types.html Grossmann, C., Goolsby, W., Olsen, L & McGinnis, J. (2010). Clinical data as the basic staple of health learning: Creating and Protecting a Public Good. Washington, D.C: National Academies Press.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

Topic 3 - 650 - Database Project Proposal - Part 2
Student’s Name
Professor’s Name
Course
Date

Topic 3 - 650 - Database Project Proposal - Part 2


The database project is aimed at creating a unified database that compiles and stores
clinical information from fragmented sources



A database schema refers to its structure (Robbins, 1995).



There are a number of business rules/policies that influence the design of the database,
directly and indirectly
Data Dictionary
Entity Relationship Diagram



One area of the design that was particularly challenging was the determination of the
relationships that exist between the various entities and attributes



Despite its noble goals, the project also had limitations. One such constraint on the
project was funding.
References

Juniata College. (2018, August 30). Three Level Database Architecture. Retrieved from
jcsites.juniata.edu/: http://jcsites.juniata.edu/faculty/rhodes/dbms/dbarch.htm
Robbins, R. J. (1995). Database Fundamentals. Retrieved from Esp.org: http://www.esp.org/dbfund.pdf


Running head: DATABASE PROJECT PROPOSAL - PART 2

Topic 3 - 650 - Database Project Proposal - Part 2
Student’s Name
Professor’s Name
Course
Date

1

DATABASE PROJECT...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags