1. Write the SQL code to create the table structures for the entities shown in Figure 1. The structures should contain the attributes specified in the ERD. 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.

3. Write the SQL command to save the rows inserted in the previous Problem.

4. Write the SQL command to change the movie year for movie number 1245 to 2010.

5. Write the SQL command to change the price code for all Action movies to price code 3.

6. Write a single SQL command to increase all price rental fee values by $0.50.

7. Write the SQL command to save the changes made to the PRICE and MOVIE tables in the previous Problems.

8. Write a query to display the movie title, movie year, and movie genre for all movies (result shown in Figure 2).

9. Write a query to display the movie year, movie title, and movie cost sorted by movie year in descending order (result shown in Figure 3).

10. Write a query to display the movie title, movie year, and movie genre for all movies sorted by movie genre in ascending order, then sorted by movie year in descending order within genre (result shown in Figure 4).

11. Write a query to display the movie number, movie title, and price code for all movies with a title that starts with the letter “R” (result shown in Figure 5).

12. Write a query to display the movie title, movie year, and movie cost for all movies that contain the word “hope” anywhere in the title. Sort