- 2 List Drug Information Pharmaceutical Company Name Trade Name Formula That Has Been Prescribed By At Least One Doc 1 (14.65 KiB) Viewed 72 times
2) List drug information (Pharmaceutical company name, trade name, formula) that has been prescribed by at least one doctor. 3) Obtain all the prescription drugs (trade name, company name and prescription date) given by Doctor “Kate Elmasri". 4) Retrieve all the drugs (trade_name, formula) sold by "Walmart". ("Walmart" is pharmacy name)
Doctor Name Specialty DSSN DOCTOR Date prescribes M Pre ne PRESCRIPTION M Consist_of Pharmacy Name Address Phone N N Name N M DRUG Sells PHARMACY Formula M Price Makes PHARMACEUTICAL COMPANY Phone Compang Name
Doctor (dssn dname, specialty) Prescription( dssn. pre_no, pdate) foreign key (dssn) references to doctor(dssn) Ph_company( pname, phone) Drug (pname, trade_name, formula) foreign key (pname) references to Ph_company(pname) Consist of (dsen, pre_no, pname, trade name) foreign key (dssn, pre_no) references prescription(dssn, pre_no), foreign key (pname, trade_name) references drug(panme, trade_name) Pharmacy (pcy_name, address, phone) Sell (pharmacy name, pname, trade name price) foreign key (pname, trade_name) references drug (pname, trade_name), foreign key (pharmacy_name) references pharmacy (pcy_name)