quay 1

  

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.