Data Model

A data model provides a view of how the data is structured throughout an organization. You’ve been provided with a set of data points from a local hospital.

Instructions:

Using the data points provided, create a model. Your data model should structure the data to support the business practices of a health care organization.

The data points should be grouped together under a category heading.

• Include a written document that describes the data model
• Each category should have a title that is descriptive.
• Develop your data model using 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’s 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:
• What is a Data Model?
• Conceptual Data Modeling Explained
• What is a Relational Database
• Defining the Basics of Health Informatics for HIM Professionals

Entity-Relationships