Fall $2024$

Assume that a prescription will always contain at least one drug but could contain more than

One drug. Further, assume that each prescription is always written by one and only one

physician, and is always associated with one and only one patient.

Finally, we would like to store information about suppliers $($i$.$e$.,$ the pharmaceutical company

that manufactures the drug$).$ When creating a relationship between drug and supplier, assume

that a drug is an id$-$dependent weak entity that is existent dependent on supplier. Assume that

some suppliers produce multiple drugs, and that a supplier produces at least one drug. Also

assume that a drug is always produced by one and only one supplier.

Draw the ER Diagram for this situation. Include relationship types using crow's foot notation,

hash marks$/$circles to indicate optional$/$mandatory relationships, and cardinalities in

parentheses notation. Don't forget to include verbs on your ER diagram. You do not need to

include attributes on your ER Diagram. When specifying your minimum cardinality, if it is not

explicit in the text, please make your best guess.

For Problem $2,$ please ensure that your ERD is well$-$formatted, and fits on one page. Please try

to get your diagram to look as professionally designed as you can. I will deduct points if there

are formatting errors.