1:43
edugate.asu.edu.jo
Assume you have the following relations:
Doctor (DocID, DocName, specialty, experience)
Patient (SSN, First_Name, Last_Name, Gender, Age, DocID)
Pharmacy (PharmacyName, Location, City, PharmacistNo)
Pharmacist (PharmacistNo, PharmacistName, Salary)
Drug (DrugNo, DrugName, formula)
Parmacy_Drug (PharmacyName, DrugNo, Price)
Doctor_Drug (DocID, DrugNo)
A. Create the Doctor table. [1 POINT]
B. Create the Patient table. [1 POINT]
c. Delete the Location attribute from the Pharmacy table. [1 POINT]
D. Retrieve the SSN, First_Name and Last_Name of all patients whose
first name ends with the letter "D". [1 POINT]
E. Retrive Pharmacy name for all farmacies located in "Amman". [1
POINT]