For this assignment, use the following database schema:1) Patient—PatientID, Name, DOB2) Doctor—DoctorID, Name, MedLicenseNumber, Phone3) Medication—MedicationID, BrandName, GenericName4) Prescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationIDSpecify the SQL queries […]