Chat with us, powered by LiveChat

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.

Words: 106
Pages: 1
Subject: Nursing

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.