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.
Your deliverable must contain the following three sections:
Each of these sections is described in more detail below.
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.)
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).
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.
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.