Use Visio to create a data model that supports a health care clinic’s business practices. Include all data points provided by the clinic in the data model.Introduction
A data model shows the structure of a database, including the relationships that determine how the data is stored and accessed. Data models also determine which data management system will be used. Most data management systems are built for a specific data model. Among the numerous types of data models are relational, conceptual, logical, physical, and entity-relationship models. Data models are represented by diagrams. In this assessment, you will use Visio to develop a data model for a specific health care scenario.Demonstration of Proficiency
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:
Competency 3: Use data analysis skills to support health information integrity and data quality.
Construct a data model that supports the clinic’s business practices.
Group data under appropriately labeled category headings.
Use data modeling symbols and notations.
Apply knowledge of data modeling concepts.
Competency 5: Communicate in a professional manner to support health care data analytics.
Create a clear, well-organized, professional document that is generally free of spelling errors.
Preparation Note: The software listed below is strongly recommended to support you in completing the course competencies. If you have access to other tools that you believe may still meet the requirements of this course, please discuss your selected alternatives with your faculty member.For this course, follow the instructions provided through the links below to download and install software or register for an account, as required.You will use Visio, available through MS Imagine, to create your data model. There is no additional cost for this software and technology. It will be made available to you through Capella’s subscription with Microsoft. Microsoft Software
If you have a Capella MS Imagine account, go to Step 2. Otherwise, see the instructions for registering an account at MS Imagine -? Registration.
Identify the version of MS Visio that is compatible with your operating system.
Download and install.
If you encounter any difficulties in the download and installation process, post a detailed question in the Ask Your Faculty Discussion in the menu dropdown when you click the image of your faculty. Note: As a Capella learner, you have access to IT online resources through Capella’s Skillsoft subscription, where you can find helpful materials.Instructions
A Vila Health Clinic has provided you, a data analyst for Vila Health, with the data points listed below. From these data points, you are to apply your knowledge of data modeling concepts and develop a data model for the clinic. Please be sure to do all of the following as you develop your data model:
Structure the model to support the clinic’s business practices.
Group the data points together under appropriate category headings.
Identify each category with a short descriptive title.
Use the symbols and notations found in entity-relationship diagrams.
Date of birth.
Sex or gender.
Social Security number.
Type of radiological test.
Physician last name.
Physician first name.
Physician telephone number.
Insurance group number.
Signs and symptoms.
Time of arrival.
Time of discharge.
Length and Format: Data model using all data points created in Visio.
Writing: Create a clear, well-organized data model that is generally free of spelling errors.