For this assignment you will solve two exercises at the end of Chapter 3, page 67, from our textbook.

First, solve Exercise 3.9 part (a), Write your solution as a valid SQL file that can be run in SQLite. Call your SQL file Problem3.9.sql. Besides the SQL DDL part of this problem, also include in your script INSERT statements that put at least a few tuples into each of the database's tables. If you want, include some incorrect insertions that show that the database is enforcing the integrity constraints.

Second, solve Exercise 3.11. Again, write your solution as a valid SQL file that can be run in SQLite. Call your SQL file Problem3.11.sql. Besides the SQL DDL part of this problem, also include in your script INSERT statements that put at least a few tuples into each of the database's tables. If you want, include some incorrect insertions that show that the database is enforcing the integrity constraints.

Turn in a zip file containing your two script files Problem3.9.sql and Problem3.11.sql that solve these two problems. This assignment is due Tuesday, September 16.