Write CREATE TABLE statements to create the tables for Midtown Memorial Patients Drug Dispennsal Database depicted by the relational schema created in mini case MC$7$ in Chapter$-3.$

Use INSERT INTO statements to insert no fewer that $2$ and no more than $10$ records per table in the Midtown Memorial Patients Drug Dispensal Database.