Capella University Health Care Clinic Business Practices Visio Data Model

Capella University Health Care Clinic Business Practices Visio Data Model

Capella University Health Care Clinic Business Practices Visio Data Model

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.




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.


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.


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.


  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.


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.


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