1. write the sql code to create the table structures for the entities shown in figure 1. the structures should contain the specified attributes. use data types that would be appropriate for the data that will need to be stored in each attribute. enforce primary key and foreign key constraints as indicated by the erd. 2. the following tables provide a very small portion of the data that will be kept in the database. this data needs to be inserted into the database for testing purposes. write the insert commands necessary to place the following data in the tables that were created in problem 1. note: for each table, you can write insert statements for 2 rows. if it works, you can copy these data to excel file. then, you can import the excel file to ms access using the method provided in access tutorial slide