Week 4 – Assignment:Explore Healthcare Data Using Structured Query Language (SQL)
In this assignment, you will demonstrate your ability to construct SQL queries at a beginning skill level and to use the results of that query for administrative decision making. While you may not be required to use SQL on a day-to-day basis, understanding the logic and the ability to read and write simple queries will enhance your insight into the storage of healthcare data—and also enable you to better communicate with the IT personnel responsible for managing that information.
The following simple relational database schema represents a core subset of EHR functionality: tracking patient encounters. The ability to track patient encounters impacts several factors, including efficiency of care, productivity, patient safety, and ultimately revenue generation, among other areas.
This database has four tables, with one table representing each category of patients, procedures, providers, and encounters. To examine this database design, observe that the encounters table has a field for storing the ID of a patient, a provider, and a procedure. An encounter comprises the enactment of a procedure by a provider for a patient.
Figure 6
simple Database Schema Example for Healthcare Encounters
Patients, procedures flow chart to encounters flowing to providers.
You are a healthcare executive who has been tasked by leadership to utilize your knowledge of SQL queries to help guide strategic planning. Leadership is considering expansion of various medical practices and needs to know the following:
1. Total number of patients seen at the organization for the year after January 1, 2019
2. The ten most common billing codes by specialty
3. Provide a count of the number of procedures per specialty
4. Ratio of providers to patients by specialty
To successfully complete this assignment, provide the steps you will take to determine each of these values using SQL queries. Include the query language for these items and the logic you used in developing the query language. Additionally, indicate how you would translate the SQL query results to practical application, to help guide the strategic planning leadership is conducting. Finally, what are the salient points related to the data that you would point out to leadership?
Length: Minimum of 3-5 pages, not including title and reference pages.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
