Answer to Question #227540 in Databases | SQL | Oracle | MS Access for Ernest

Question

Question 2

a. Describe the basic features of the relational data model and discuss their

importance to the end user and the designer.

b. 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.

i. Identify the business rules for PATIENT, ORDER, and

MEDICATION.3

ii. Create a Crow's Foot ERD that depicts a relational database model

to capture these business rules.

c. Using an example in each case, explain the significant difference between

homonyms and synonyms and explain why should they be avoided in database

design?

Answer 1

Dear Ernest, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order