Data Model

Assignment Instructions

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.

• Using the data points provided, develop a data 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.
• Each category should have a title that is short but 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? https://www.youtube.com/watch?v=4qFZ-5i4GS8
• Conceptual Data Modeling Explained: https://www.youtube.com/watch?v=O4PXqpv8TAw
• What is a Relational Database: https://www.youtube.com/watch?v=zhu6jtlghIs
• Defining the Basics of Health Informatics for HIM Professionals: http://library.ahima.org/doc?oid=107443#.WREtV1XyvIU
• Entity-Relationships: https://www.youtube.com/watch?v=-fQ-bRllhXc