For this assignment:

$-$ Insert the given data from the image into the tables. You may keep the names of your tables and columns if you wish.

$-$ You may have to drop and recreate the tables if you need to adjust the data types based on the given data.

$-$ Submit the script file $(.$sql$)$ that includes:

$-$ the corrected create table statements

$-$ the insert into statements

$-$ the select $*$ from each table statement along with the run result

$-$ capture the run result in a file.