Write a SQL statement to create the database for the case study. 1. Write SQL statements to create at least two tables from the case study. The tables must have columns with appropriate types, a primary key and at least one table should have a foreign key and the related foreign key constraints. 1. Write a SQL query to modify one of the tables in some way (add or change a column, etc.) 1. Insert at least two rows in each of the tables. 1. Write a SQL query to update one row in one of the tables.