Q1. Design an ER diagram for a Pharmacy. The pharmacy stocks various medicines. Each medicine is uniquely identified by a Batch Number. The system maintains information about the medicine's name, price, quantity in stock, date of manufacture, and date of expiry. The pharmacy sells these medicines only to the patients who are registered with it. It stores the Patient ID, Name, Address and Phone Number for each the patients. All sales transactions are duly recorded along with the date of the transaction. A single transaction may consist of multiple medicines. Design an ER diagram for the scenario above. You should clearly list the following: Make and state suitable assumptions, if any.
- (i)) Entities and Attributes. (300 words)
- (ii)) Relationships and their Cardinality (300 words)
- (iii)) Key Constraints (Primary/Foreign Keys). (300 words)