GCU HIM650 2022 May Week 2 Discussion (dq1+dq2) Latest

HIM650 Health Care Data Management

Week 2 Discussion

DQ1 Who would be the ideal candidate(s) from whom to elicit information during the requirements gathering and analysis phase of the database project? Explain why.

DQ2 Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication.

Identify different entities from this scenario.

Create an entity-relationship diagram illustrating 1:1 and 1:many relationships.

Compare your ERD with another classmate's and discuss the differences each of you had.