Your goals for this assignment are to:

1. Modify your ER diagram based on the feedback you received on the earlier assignment.
2. Design and build your database as a set of tables in the Oracle system, as well as populating your tables with data.

You (or your group) must hand in printed copies of the following:

1. The graded copy of your original ER assignment (for reference)
2. A new copy of the (modified) ER diagram which you use as a model for this assignment.
3. printout of file tables.sql described below.
4. printout of file values.sql described below.
5. printout of file queries.sql described below.
6. printout of file results described below.

The .sql files should be ones which can be sourced directly on the Oracle system. Here are specific requirements for each part:

1. tables.sql

   This file should be a script which creates all of your tables.

   Tables should have:

   • Primary keys
   • appropriate Foreign keys
   • appropriate null constraints
   • appropriate check constraints
   • some default values

2. values.sql

   This file should be a script which populates all of your tables with data (whether real or artificial), which clearly illustrates the design of the database.

3. queries.sql

   This file should be a script which demonstrates meaningful queries (including joins), demonstrating that the data you entered makes sense and illustrating the relationships between tables. Some group by and sorts would also be interesting.

4. results

   Save here some representation (e.g., text, html) displaying the results when executing queries.sql on your database.