Question

Based on the description below, answer problems 7-8 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. 7. Identify the business rules for PATIENT, ORDER, and MEDICATION. 8. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules. Answer problems 9-10 for the UBA database United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting is exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is painted by a single painter, but each painter can paint many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database: 9.Identify the business rules for PAINTER, PAINTING, and GALLERY. 10. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules.

Answer 1

PATIENT
1. Each patient will have some id (primary key).
2. They will have name, address, phone number, ema

il-id.

Relation between PATIENT and ORDER is of one to many.

ORDER
1. Each order will have some id (primary key).
2. Quantity of each medicine
3. Cost to be paid

Relation between ORDER and MEDICINE is of one to many.

MEDICINE
1. Each medicine will have some id (primary key).
2. Cost per unit.
3. Strength of medicine.

ORDER PATIENT * Patient id orders * order id quantity of medicine cost address phone number email-id wo A MEDICINE * medicine-id mediune name Strength