Instructions A data model provides a view of how the

 

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.

Instructions:

  • 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.
  • Include a written document (1 1/2 -2) pages 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: