question is in the picture

After reviewing your EERD and making modifications as needed, your next step is to create the tables needed. Using the following table overview, write the SQL statements that will create the tables, columns, primary keys, and any foreign keys. All SQL statements must be in .sql file. You must include the following: 1. Drop statements for all tables must be done first. 2. Create statements for all tables must be done second. Remember the order is important. Drop all tables with foreign keys first, then drop all tables with just primary keys. Create all tables with primary keys first, then all tables with foreign keys