HIMA410 Week 4 Assignment: Data Models Essay

Week 4 Assignment: Data Models

A data model is a visual portrayal of the elements of a database. The most prevalent data model is the ERD (Entity Relationship Diagram). To appropriately build an ERD, it is critical first to determine what would form the attributes and entities. The cardinalities indicate the relationship between such entities (Yarlagadda & Syed, 2016). The data sets are classified (into Tables). In the provided case, the resultant ERD is the following: patients, labs, ordered tests, medical insurance, and doctors. The relevant cardinalities will demonstrate the link between the identified entities. There exist six cardinalities in a basic ERD framework (Gravelle, 2010). This will characterize the relations between the entities as many-to-many, many-to-one, one-to-many, one-to-one, zero-to-many, and one-to-zero.

ORDER A PLAGIARISM-FREE PAPER HERE

In the given scenario, one doctor can serve many patients, but one doctor can help one patient at a time representing a one-to-one relationship. The doctor may order one or more tests to be done by the radiologist for every patient, but one test that may be requested is linked to one patient. This implies that the doctor and the test requested table will have a one-to-many relation. Lab test and ordered test have a one-to-many relation. In this situation, the lab test will also have a one-to-one relationship with the requested test. Because a doctor can only ask for a specific test, there may be a one-to-one association between lab test results and doctors. Each appointment has both a check-in and a check-out time. Because a particular insurance policy is linked with a single patient, patient and medical insurance entities will have a one-to-one relationship.

Figure 1: ERD Diagram

References

Struggling to meet your deadline ?

Get assistance on

HIMA410 Week 4 Assignment: Data Models Essay

done on time by medical experts. Don’t wait – ORDER NOW!

Gravelle, R. (2010, October 8). Cardinality in MySQL data modeling. Database Journal. https://www.databasejournal.com/mysql/cardinality-in-mysql-data-modeling/

Yarlagadda, R. T., & Syed, H. H. (2016). Data Models in Information Technology. SSRN Electronic Journal, 3(2), 1–9.

Week 4 Assignment : Data Model** – Due

Jan 30, 2022 11:59 PM

HIMA410 B001 Winter 2022

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 (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:

HIMA410 Week 4 Assignment: Data Models Essay