Design an ER diagram that shows the main tables used in a pharmacy. The tables are Patient, Drug, Prescription, Doctor, and Vendor. Show in the ER diagram the main entities with their attributes as well as the relations between the entities. After finishing the ER diagram, construct the tables with their attributes and relations using MySQL DBMS.

Answer rating: 100% (QA)

Step 1 Listing entities and adding attributes As needed the system will have below entities with the appropriate attributes in it 1 Patient PatientID PName PAddress PPhone PDateOfBirth 2 Drug DrugID N... View the full answer