Database
create a simple database in Excel pertaining to healthcare, patients etc…
1. Explain how the rows and columns you created would help you further analyze the information.
2. Submit the database with explanation of how a database is created and how it functions.
Include Reference
Example spread sheet
http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database.htm
Example 1
Patient and Provider Health outcomes
EMR # Last Name Initial. age Illness provider
134-427. Anderson M. 32 diabetes Dr. Rodgers
134-428. Dodson C. 45. diabetes Dr. Rodgers
134-429 LuGrand S. 33. anemia. Dr. Jeffery
134-430. Louis V. 27 diabetes. Dr. Rodgers
134-431. Raymond. P. 73. hypertension Dr. Seay
134-432. Thomas T. 85. arthritis. Dr. Jeffery
Example 2
Hospital Payer Claims 2020-2021
Payer ID Payer # Claims Outstanding Visit Type Date of Oldest Claim
56-24873198 Aetna 81 Inpatient 1/6/2020
57-24873199 Caresource 66 Outpatient 2/14/2020
58-24873200 Molina Healthcare 23 Emergency 6/16/2020
56-24873199 Buckeye 19 Outpatient 5/14/2020
57-24873200 United Health Group 77 Inpatient 3/13/2020
58-24873201 Anthem 53 Inpatient 3/3/2020
56-24873200 Tricare 14 Outpatient 1/10/2020
57-24873201 Humana 63 Emergency 4/16/2020
58-24873202 Cigna 52 Outpatient 7/15/2020
56-24873201 Optum Health 95 Inpatient 6/27/2020
56-24873199 Superior 11 Emergency 1/31/2020
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
