Reference no: EM132288373

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?

• Conceptual Data Modeling Explained

• What is a Relational Database

• Defining the Basics of Health Informatics for HIM Professionals

• Entity-Relationships.