Data Model for Health and Medical Questions

Data Model for Health and Medical Questions

Instructions  

Data Model for Health and Medical Questions

Instructions for Assessment 4: Modeling Data

Create a data model in Visio to support the business processes of a health care clinic. In the data model, include all of the clinic’s data points.
INTRODUCTION
A data model depicts a database’s structure, as well as the relationships that dictate how data is stored and retrieved. The data model also determines the data management system to be utilized. The majority of data management solutions are designed to work with a specific data model. Relational, conceptual, logical, physical, and entity-relationship models are among the many types of data models. Diagrams are used to represent data models. You will use Visio to create a data model for a specific health-care scenario in this assessment.
PROFICIENCY DEMONSTRATION
You will demonstrate your proficiency in the course competencies by successfully completing this assessment using the following assessment scoring guide criteria:
Competency 3: Apply data analysis skills to ensure the integrity and quality of health data.
Construct a data model that is supportive of the clinic’s operations.
Data should be organized into categories that are clearly defined.
Use symbols and notations for data modeling.
Apply your understanding of data modeling ideas.
Competency 5: Support health care data analytics by communicating in a professional manner.
Create a professional paper that is clear, well-organized, and devoid of spelling problems.
PREPARATION
Note: Using the tools described below to help you complete the course competencies is highly encouraged. Please explore your chosen alternatives with your faculty member if you have access to additional resources that you believe may still fit the requirements of this course. Follow the directions in the links below to download and install software or register for an account, as needed, for this course. To construct your data model, you’ll utilize Visio, which is offered through MS Imagine. This software and technology come at no additional cost. It will be made available to you as part of Capella’s Microsoft subscription.
SOFTWARE BY MICROSOFT
Go to Step 2 if you have a Capella MS Imagine account. Otherwise, go to MS Imagine – Registration for instructions on how to create an account.
Access the Capella Microsoft Imagine Webstore by logging in.
Determine which MS Visio version is compatible with your operating system.
Install the software after downloading it.
If you have any problems during the download and installation process, please post a thorough question in the Ask Your Faculty Discussion under the menu dropdown when you click your faculty’s image. Note: You have access to IT online resources through Capella’s Skillsoft subscription as a Capella learner, where you can find useful materials.
INSTRUCTIONS
The data points shown below were submitted by a Vila Health Clinic to you, a Vila Health data analyst. You must use your knowledge of data modeling ideas to create a data model for the clinic based on these data points. Please be sure to include all of the following in your data model development:
Organize the model to support the clinic’s operations.
The data points should be grouped together under relevant category titles.
Create a short descriptive title for each group.
Entity-relationship diagrams have symbols and notations that you can use.
Points of Information
Identification of the consumer.
Your last name.
This is your first name.
Date and place of birth
Gender or sex.
The address is on the street.
City.
State.
ZIP code is an abbreviation for Postal Code.
Number to call.
Number assigned by the Social Security Administration.
This is a type of radiological examination.
The date the order was placed.
Last name of a physician.
First name of the physician.
Specialization in medicine.
Identification of a physician.
The phone number for the doctor.
Name of the insurance company.
The number of the insurance group.
Type of insurance.
The date on which the policy becomes effective.
Date of expiration.
Signs and symptoms are used to make a diagnosis.
The issue at hand.
The arrival time.
Discharge date and time.
REQUIREMENTS ADDITIONAL REQUIREMENTS
Length and Format: Data model generated in Visio with all data points.
Writing: Create a well-organized, unambiguous data model that is free of spelling problems.
Resources: Data Management

P. N. Buffone, P. N. Buffone, P. N. Buffone (2016). The panacea for data exchange in the twenty-first century. Pharmaceutical Executive, vol. 36, no. 8, pp. 39, 50.
Undergraduate Library Research Guide for Capella University’s Health Care Administration Program.
Please use this guide to undertake independent research on course topics as needed. This tool will help you find scholarly, peer-reviewed, and authoritative resources.
L. Kadlec, L. Kadlec, L. Kadlec (2014). Soon to arrive at your healthcare facility: Information governance – A look at current developments in healthcare information governance through case studies. AHIMA Journal, 85(8), 26–32.
S. Kersten (2013). Optimizing the EHR through information governance: Moving the needle toward a data-driven health-care system. 15(3), 45–46, 62, Journal of Health Care Compliance.
D. Marbury (2016). Dream versus. reality in terms of interoperability. 26(10), 29–31 in Managed Healthcare Executive.
N. Simon (2016). The fear of sharing data. 25 in Health Management Technology, vol. 37, no. 8. esources: Data Modeling esources: Data Modeling esources: Data Modeling esources: Data Modeling
PRINT
1keydata.com is a website that provides information on 1keydata.com (n.d.). Conceptual, logical, and physical data models are all types of data modeling. https://www.1keydata.com/datawarehousing/data-mode… was retrieved from https://www.1keydata.com/datawarehousing/data-mode…
S. W. Ambler, S. W. Ambler, S. W. Ambler (n.d.). The fundamentals of data modeling. http://www.agiledata.org/essays/dataModeling101.htm was retrieved from http://www.agiledata.org/essays/dataModeling101.htm
The principles of data modeling are discussed in this article, as well as how it is applied in practice. Examine the data models that have been provided as examples.
S. Arunachalam, T. Page, and G. Thorsteinsson (2017). i-Journal Manager’s on Computer Science, 4(4), 1–13. Healthcare data warehousing.
Lucidchart is a program that allows you to create diagrams (n.d.). What is the definition of a database model? The database diagram was derived from https://www.lucidchart.com/pages/database-diagram/…
C. Mazzali and P. Duca (2015). In healthcare research, administrative data is used. 517–524, Internal and Emergency Medicine, vol. 10, no. 4, pp. 517–524.
M. J. Rho, S. R. Kim, S. H. Park, K. S. Jang, B. J. Park, J. Y. Hong, and I. Y. Choi (2016). To extract knowledge from a multi-center database, a common data model for a decision support system for adverse drug reactions was developed. 57–66 in Information Technology and Management, vol. 17, no. 1.
Data Modeling Resources

1keydata.com is a website that provides information on 1keydata.com (n.d.). Conceptual, logical, and physical data models are all types of data modeling. https://www.1keydata.com/datawarehousing/data-mode… was retrieved from https://www.1keydata.com/datawarehousing/data-mode…
S. W. Ambler, S. W. Ambler, S. W. Ambler (n.d.). The fundamentals of data modeling. http://www.agiledata.org/essays/dataModeling101.htm was retrieved from http://www.agiledata.org/essays/dataModeling101.htm
The principles of data modeling are discussed in this article, as well as how it is applied in practice. Examine the data models that have been provided as examples.
S. Arunachalam, T. Page, and G. Thorsteinsson (2017). i-Journal Manager’s on Computer Science, 4(4), 1–13. Healthcare data warehousing.
Lucidchart is a program that allows you to create diagrams (n.d.). What is the definition of a database model? https://www.lucidchart.com/pages/database-diagram/ retrieved from https://www.lucidchart.com/pages/database-diagram/ …
C. Mazzali and P. Duca (2015). In healthcare research, administrative data is used. 517–524, Internal and Emergency Medicine, vol. 10, no. 4, pp. 517–524.
M. J. Rho, S. R. Kim, S. H. Park, K. S. Jang, B. J. Park, J. Y. Hong, and I. Y. Choi (2016). To extract knowledge from a multi-center database, a common data model for a decision support system for adverse drug reactions was developed. 57–66 in Information Technology and Management, vol. 17, no. 1.
2 pages are required.

RUBRIC
Excellent Quality 95-100%	Introduction 45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.		Literature Support 91-84  points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.			Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score 50-85%	40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.		83-76  points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.			52-49  points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality 0-45%	37-1 points The background and/or significance are missing. No search history information is provided.		75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.			48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.perfectacademic.com/orders/ordernow or www.crucialessay.com/orders/ordernow Data Model for Health and Medical Questions

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!