Project: Your Favorite Database.

Create a database for your favorite subject: Stamp Collecting, CD, Club Event, etc.


Minimum Requirements:

In one or two paragraphs explain the system that you are designing the database for.
5 or more Tables in a normalized design.
Draw out an ER Diagram (we will discuss in class)
CREATE TABLE statements with full definitions:
Primary Keys
Foreign Keys
Other Constraints.
CREATE appropriate Indices for performance.
CREATE SEQUENCES for primary keys. Sequences should be automatically assigned in a trigger.
Remember the database should defend itself and enforce it's own rules. This means liberal use of constraints and triggers.
3 or more VIEWS to simplify the perception of the database to the user and/or for reporting purposes.
1 Trigger for each table at a minimum creating the primary key and maintaining a history table.
PL/SQL Packages for each table to encapsulate all DML commands such as INSERT, UPDATE, DELETE.



Turn In:  All Source code, scripts to create tables, and testing results.