| Deliverable |
Weight |
Due Date |
Description |
Proposal
<Sample>
|
4% |
September 19 |
An initial draft of the proposal must be submitted on September 19th.
The proposal outlines the general goals of the project:
the "business" concept to be modelled, specific informational attributes that must be stored,
and questions that the populated database will be expected to answer.
The instructor will then return this draft, unmarked, but with comments or suggestions concerning the scope of the proposed project.
|
| October 3 |
The final, or refined, draft of the proposal is due October 3rd.
This version of the proposal should incorporate some or all of the changes recommended by the instructor,
as well as any other modifications that came to light in the time since the initial draft was submitted.
This version of the proposal will be graded and is worth 4% of the term mark.
|
Conceptual Model
<Sample>
|
4% |
October 17 |
This deliverable is composed primarily of the Entity-Relationship model diagram describing the project design.
|
Physical Design
<Sample>
|
4% |
October 31 |
The Physical Design is submitted as both a Relational Schema diagram of the design and the SQL DDL scripts used to produce the schema.
The schema must also be implemented on the course's Oracle server database.
|
DML Population Scripts
<Sample>
|
4% |
November 14 |
This deliverable is a set of SQL DML scripts that populate the relational schema.
|
DML Query Scripts
<Sample>
|
4% |
November 28 |
This deliverable is a set of SQL DML scripts that query the database to answer the questions originally posed by the client.
|
|
Final Project Submission
|
10% |
December 12 |
This deliverable is a resubmission of all of the previous deliverables, incorporating any new ideas that cropped up along the way,
or suggestions made by the instructor as the deliverables were returned.
|
| Total Term Weight: |
30% |
|
