Assignment Task:
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.