CSC 4480: Principles of Database Systems
Project Phase 4: DDL Schema and DML Population

For this deliverable you'll use SQL to implement the relational schema you designed in the previous project phase and populate it with business data.

Deliverable Format

Your deliverable must contain the following three sections:

  1. The SQL script used to create and populate the schema tables,
  2. A listing of the contents of all of the tables in your project schema, and
  3. Descriptions of any changes from previous deliverables.

Each of these sections is described in more detail below.

1.   SQL Script File

Write the SQL DDL scripts necessary to produce the relational schema diagram you developed in the previous project phase. Include SQL DML statements as part of your script to populate your tables with data.

You should populate your database with enough data to make it "interesting". In other words, insert at least a half-dozen rows into the most important tables in your schema, and try to create these rows so that they capture most of the possibilities implied by your design.

Your schema must use surrogate keys for at least one table, which must have foreign keys that reference the surrogate keys.

Do not refer to surrogate key values literally when inserting data into foreign key tables; instead, use the INSERT INTO SELECT syntax to retrieve those values as needed. (See the sample deliverable for an example.)

2.   Table Contents

Include a document showing the contents of every table in your database schema (Use "SELECT * FROM table;" to accomplish this.)

Please ensure that the columns are vertically-aligned in your document(i.e. use a non-proportional font such as Courier New).

3.   Changes from the Previous Deliverables

In this section, document changes in the design of this project from that described in the previous two deliverable.

Check out the sample deliverable for this part of the project.

Submission

Upload your solution on the project website. If you made any changes to previous project deliverables, you must resubmit (re-upload) the modified versions showing the changes. In this case, please highlight the changed requirements in some way. All deliverables must be kept consistent.