Using SQL$,$ create tables according to the given schema shown in Figure $1$ and the ER diagram is shown in Figure $2.$ You must create your database using exactly the same names $($case sensitive$)$ for tables and attributes. You can decide the type of each attribute. You are required to specify the following constraints: domain constraint, entity integrity constraint, key constraint, and referential integrity constraint.

See Figure $1$

Then do again for Figure $2$

$(1)$ Populate the database. Insert at least two tuples to the $$Sell$$ table. For each of the other tables, insert at least one tuple.

$(2)$ Execute one delete statement to the $$Sell$$ table. You can decide the delete condition.

$(3)$ Execute one update statement to the $$Drug$$ table by changing the value of $$formula$.$

$(4)$ Specify the statements to drop all the tables. Pay attention to the order of the drop statements in order to drop everything successfully.