Health Medical Homework Help

Data Model that Supports a Health Care Clinic Business Practice Discussion

 

  • 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

    1. If you have a Capella MS Imagine account, go to Step 2. Otherwise, see the instructions for registering an account at MS Imagine -’ Registration.
    2. Log in to the Capella Microsoft Imagine Webstore.
    3. Identify the version of MS Visio that is compatible with your operating system.
    4. 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.
    Data Points
    • Consumer ID.
    • Last name.
    • First name.
    • Date of birth.
    • Sex or gender.
    • Street address.
    • City.
    • State.
    • ZIP code.
    • Telephone number.
    • Social Security number.
    • Type of radiological test.
    • Date ordered.
    • Physician last name.
    • Physician first name.
    • Physician specialty.
    • Physician ID.
    • Physician telephone number.
    • Insurance name.
    • Insurance group number.
    • Insurance type.
    • Effective date.
    • Expiration date.
    • Diagnosis.
    • Signs and symptoms.
    • Presenting problem.
    • Time of arrival.
    • Time of discharge.

    Additional Requirements

    • 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.

    If you use assistive technology or any alternative communication methods to access course content, please contact Disability Services with any access-related questions or to request accommodations.

  • SCORING GUIDE

    Use the scoring guide to understand how your assessment will be evaluated.VIEW SCORING GUIDE

  • CRITERIA NON-PERFORMANCE BASIC PROFICIENT DISTINGUISHED
    Construct a data model that supports the clinic’s business practices. Does not construct a data model that supports the clinic’s business practices. Attempts to construct a data model that supports the clinic’s business practices. However, omissions and/or errors exist. Constructs a data model that supports the clinic’s business practices. Constructs a data model that supports the clinic’s business practices. Model provides rationale for selection of the data model and includes references to current scholarly and/or authoritative sources.
    Group data under appropriately labeled category headings. Does not group data under appropriately labeled category headings. Attempts to group data under appropriately labeled category headings; however, omissions and/or errors exist. Groups data under appropriately labeled category headings. Groups data under appropriately labeled category headings. Model provides rationale for data groupings and category headings along with references to current scholarly and/or authoritative sources.
    Use data modeling symbols and notations. Does not use data modeling symbols and notations. Attempts to use data modeling symbols and notations. However, omissions and/or errors exist. Uses data modeling symbols and notations. Uses data modeling symbols and notations without errors or omissions.
    Apply knowledge of data modeling concepts. Does not apply knowledge of data modeling concepts. Attempts to apply knowledge of data modeling concepts; however, omissions and or errors exist. Applies knowledge of data modeling concepts. Applies knowledge of data modeling concepts. Model incorporates best practices and supports best practices with references to current scholarly and/or authoritative sources.
    Create a clear, well-organized, professional document that is generally free of spelling errors. Does not create a clear, well-organized, professional document that is generally free of spelling errors. Attempts to create a document that is clear, well organized and generally free of spelling errors. However, lapses, omissions, and/or errors exist. Creates a clear, well-organized, professional document that is generally free of spelling errors. Creates a clear, well-organized, error-free, professional document.