2DQ1-2-650

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.