A data model provides a user’s view of how the data should be structured and displayed. It also provides an understanding of how information is acquired and required to support business practices within an organization.
In this assignment, you will use Visio to develop a data model for a specific scenario.
Instructions
You have been provided the following data points from a Vila Health clinic. Using the data points provided, develop a data model for the Vila Health clinic; apply your knowledge of data modeling concepts. 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. Use Visio to create your model. You may also use Courseroom Software Resources linked in the Resources for Visio.
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’s last name.
Physician’s first name.
Physician’s specialty.
Physician’s ID.
Physician’s 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.
Submission Requirements
Written communication: Written communication should be clear and generally free of grammatical errors.
Format: Word and Visio documents.
APA formatting: Use APA style and format for the paper, references, and citations.
Length of paper: Diagram plus two pages of text.
Font and font size: Times New Roman, 12 point.