A SQL script containing your data definition language (DDL) statements to create tables, views, triggers, and other required database objects for your project. Your script must also include queries to demonstrate that all objects are developed successfully (i.e. selecting from the database catalog/data dictionary using user_objects and user_tables). A separate document that contains the complete textual output from running your DDL scrip.

Drop Statements for All Objects as needed (5 points)

Statements for All Tables and Constraints (30 points)

Indexes for Natural, Foreign Key, and Frequently Queried Columns (10 points)

Create a Minimum of Two Views (10 points)

Create a Minimum of Two Sequences (10 points)

Create a Minimum of Two Triggers (10 points)

Describe the Business Purpose of your Views and Triggers (5 points)

Database Catalog/Data Dictionary Queries (5 points)

Output Report (5 points)

Executable, Error-Free Script (10 points)

Deliverable:

DDL Script in SQL or TXT: LastName_FirstName_DDL.[sql|txt]

Script Output Report: LastName_FirstName_output.[doc|docx]