Step 1: Identify Entities Identify all the entities mentioned in the problem statement. These include Drugstore, Patient, Doctor, Drug, PharmaceuticalCompany, Prescription, Contract, and Supervisor. Step 2: Define Attributes For each entity, list the attributes mentioned in the problem statement. For example: Drugstore: StoreID, StoreName, Address, Phone Patient: PatientID, Name, Address, Age, PrimaryDoctorID Doctor: DoctorID, Name, Specialty, YearsOfExperience Drug: DrugID, TradeName, Formula PharmaceuticalCompany: CompanyID, CompanyName, Phone Prescription: PrescriptionID, Date, Quantity Contract: ContractID, StartDate, EndDate, ContractText Supervisor: SupervisorID, Name Step 3: Identify Relationships Based on the interactions mentioned in the problem statement, identify the relationships between entities. For example: Drugstore sells Drug (many-to-many) Doctor prescribes Drug for Patient (many-to-many) Patient has Primary Doctor (one-to-one) Drugstore has Contract with Pharmaceutical Company (many-to-many) Pharmaceutical Company produces Drug (one-to-many) Contract has Supervisor (one-to-many) Step 4: Draw the Diagram Using a drawing tool like Lucidchart, draw.io, or Microsoft Word, create boxes representing each entity and connect them with lines to represent relationships. Include cardinality and participation constraints as necessary. Step 5: Add Attributes and Keys Inside each entity box, list the attributes and indicate primary keys with underline. Add foreign keys where necessary to maintain relationships. Step 6: Finalize and Review Review your diagram to ensure all entities, relationships, attributes, and constraints are accurately represented. Make any necessary adjustments. Step 7: Save and Submit Save your diagram as a DOC/DOCX/PDF file with your FirstName_LastName_A2.doc/docx/pdf. Add your name and student number at the top of the file an