Data model

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 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.