MUST FOLLOW GRADING RUBRIC

MUST HAVE AND 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.

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.

Resources: Data Governance

• PRINT
• • Buffone, P. N. (2016). The 'cure'-all for 21st century data sharing. Pharmaceutical Executive, 36(8), 39, 50.
  • Capella University Health Care Administration Undergraduate Library Research Guide.
    • Please consult this guide as needed to conduct independent research on course topics. This resource will direct you to scholarly, peer-reviewed, and authoritative resources.
  • Kadlec, L. (2014). Coming soon to your healthcare facility: Information governance – A look at healthcare information governance trends through practical case studies. Journal of AHIMA, 85(8), 26–32.
  • Kersten, S. (2013). Moving the needle toward a data-driven health care system: Optimizing the EHR through information governance. Journal of Health Care Compliance, 15(3), 45–46, 62.
  • Marbury, D. (2016). Interoperability: Dream vs. reality. Managed Healthcare Executive, 26(10), 29–31.
  • Simon, N. (2016). The dread of data sharing. Health Management Technology, 37(8), 25.

  Resources: Data Modeling

  • PRINT

  • • 1keydata.com. (n.d.). Data modeling – Conceptual, logical, and physical data models. Retrieved from https://www.1keydata.com/datawarehousing/data-mode…
    • Ambler, S. W. (n.d.). Data modeling 101. Retrieved from http://www.agiledata.org/essays/dataModeling101.ht…
      • This article discusses the fundamentals of data modeling and how it is used in practice. Examine the sample data models.
    • Arunachalam, S., Page, T., & Thorsteinsson, G. (2017). Healthcare data warehousing. i-Manager's Journal on Computer Science, 4(4), 1–13.
    • Lucidchart. (n.d.). What is a database model. Retrieved from https://www.lucidchart.com/pages/database-diagram/…
    • Mazzali, C., & Duca, P. (2015). Use of administrative data in healthcare research. Internal and Emergency Medicine, 10(4), 517–524.
    • Rho, M. J., Kim, S. R., Park, S. H., Jang, K. S., Park, B. J., Hong, J. Y., & Choi, I. Y. (2016). Common data model for decision support system of adverse drug reaction to extract knowledge from multi-center database. Information Technology and Management, 17(1), 57–66.

    Resources: Visio

    • PRINT
    • Assessment 4 requires you to use Visio to create a data model. If you are new to Visio, you may find these Skillsoft video tutorials helpful:
      • Welton, T. (2016). Creating and managing diagrams in Visio 2016 [Video].
      • Welton, T. (2016). Getting started with Visio 2016 [Video].