you can use paper and draw the ERD diagram or you can use Microsoft Word or PowerPoint to create ERD diagram.

3. Use the following business rules to create a Crow's foot ERD. Create necessary Entities and find the cardinality and modality for every relationship. (7 points) 1. A pharmaceutical company manufactures one or more drugs, and each drug is manufactured and marketed by exactly one pharmaceutical company. 2. Drugs are sold in pharmacies. Each pharmacy has a unique identification. Every pharmacy sells one or more drugs, but some pharmacies do not sell every drug.. Each drug can be sold by many pharmacies. There might be some drugs that are not sold anywhere. 3. Each Drug that is launched is tested by a Lab. A Lab can test zero or many drugs and each drug can be tested in multiple labs. Every drug has to be tested by at least one lab