For each prescription assume you need to record the drug, the dosage, the pharmacist who prepared the prescription, the nurse that administered the prescription, the doctor, the patient, date, and other important information like the manufacturer of the drug. Create your ERD diagram in Visio and submit along with the names of the group Note1, to get Visio to use crows feet notation, you need to create the document, then select database-options- document, then click on crows feet checkbox. Note 2, Visio does not have a many to many connector, instead, use two one-to-many connectors Check to make sure your diagram support the following queries (make sure you consider all of the required entities): . List of doctors who have ever prescribed Zantac List of patients who have been prescribed Cipro List of drugs a particular patient has taken List of the side effects of a drug List of possible drug interactions for a given drug Given a patient and a new medication, a list of their existing meds that might cause an interaction Amount owed by patient The pharmacists that filled a particular prescription A list of prescriptions a pharmacists has filled this week The doctor who has written the most prescriptions in the last 30 days The doctor who has written the largest dollar value of prescriptions this year . The amount of a drug that has been prescribed in the last 90 day:s The supply on hand of a particular drug. For each prescription assume you need to record the drug, the dosage, the pharmacist who prepared the prescription, the nurse that administered the prescription, the doctor, the patient, date, and other important information like the manufacturer of the drug. Create your ERD diagram in Visio and submit along with the names of the group Note1, to get Visio to use crows feet notation, you need to create the document, then select database-options- document, then click on crows feet checkbox. Note 2, Visio does not have a many to many connector, instead, use two one-to-many connectors Check to make sure your diagram support the following queries (make sure you consider all of the required entities): . List of doctors who have ever prescribed Zantac List of patients who have been prescribed Cipro List of drugs a particular patient has taken List of the side effects of a drug List of possible drug interactions for a given drug Given a patient and a new medication, a list of their existing meds that might cause an interaction Amount owed by patient The pharmacists that filled a particular prescription A list of prescriptions a pharmacists has filled this week The doctor who has written the most prescriptions in the last 30 days The doctor who has written the largest dollar value of prescriptions this year . The amount of a drug that has been prescribed in the last 90 day:s The supply on hand of a particular drug
