Consider the Prescriptions-R-X ER diagram. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. Assume that, if a Doctor Prescribes the same drug for the same patient more than once, only the last such prescription needs to be store.

name address name speciality san Age exp SSN Patient Pri_phy Doctor Address Date name phone Prescription Qty Pharmacy Sell Drug Trade_name price Formula Contract Make End_d name text Start_d Pharma_Co supervisor phone