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.