This course is closed. The accuracy of this page's content is not guaranteed. [Return to college.yukondude.com]

Yukon College COMP 220 - Winter 2003
Database Design II
Outline Calendar Notes Project Resources Site Print Preview Contact Instructor

Term Project

You will plan, design, and construct a database-driven web application ("weblication") as your individual term project. You will proceed through all of the stages typical to the development of such projects in the real world: from the requirements-gathering stage, right through to the perilous demonstration of the completed application to the client. You are free to choose any theme you wish for your application: perhaps something work- or hobby-related.

Regardless of your choice, it is more than likely that the scope of your project will grow. This will especially be the case if you choose a work-related topic for your project--precisely because you will be aware of the complexities of the problem domain, and will want to model them faithfully. This "scope-creep" is the reason for the two drafts of the project proposal; you may need to be reigned in a bit after the first draft so that your final proposal isn't overly ambitious.

Although you are expected to work on your project by yourself, class members are encouraged to share their ideas and code. Students that incorporate pieces of other projects into their own are required to first solicit permission to borrow the code, and then must also acknowledge the original author of the code in both internal (comments) and external documentation.

The instructor will also build a parallel project, intended both as a reference for marking purposes and as a method to ensure that the individual student projects remain somewhat synchronized. The deliverables from the instructor's project will be posted to this page.

Project Webserver

All of the student project websites can be found by visiting the project server's home page <199.247.245.45>.

Requirements

To be elligible for full marks, the final release of your project must include:

  • at least six application screens (HTML pages), not including those used for purely administrative purposes (e.g. managing users, or a logon screen);
  • the facility for authorized users or the public to search for specific records relevant to the problem domain;
  • at least one onscreen report that meets the business needs of the client;
  • at least two different types of user account (roles);
  • the facility to add, change, and remove users; and
  • a logon screen for users requiring authentication, as well as a logoff mechanism.

In addition, all of the generated HTML pages that make up your application must conform to either the HTML 4.01 Specification or the XHTML 1.0 Specification. In either case your pages may conform to the Strict (difficult) or Transitional (easier) versions of the specification.

Deliverables

The project will be graded as a series of deliverables to be submitted on specified dates. Please remember that all deliverables must be submitted at the beginning of class (6:00 pm) on the date they are due. Late deliverables will be penalized 20% per working day, unless prior arrangements have been made with the instructor.

To view the detailed description of each deliverable, click the links in the Deliverable column below. These descriptions will be posted to the site over the course of the term, and will also be handed out in class.

Deliverable Weight Due Date Description
Proposal
<Sample>
5% Jan. 23 An initial draft of the proposal must be submitted on January 23rd. The proposal outlines the business problem to be solved, an outline of the user scenarios that make up the application, and the construction timeline for the project's three releases. The instructor will then return this draft, unmarked, but with comments or suggestions concerning the scope of the proposed project.
Jan. 30 The final, or refined, draft of the proposal is due January 30th. 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 5% of the term mark.
Conceptual Model
<Sample>
5% Feb. 6 The conceptual model deliverable will include the entity-relationship model of the project's database, together with the application's scenario and screen flowcharts.
Prototype
<Sample>
5% Feb. 20 The prototype consists of an online mock-up of the application of sufficient detail to account for the scenarios defined in the proposal. The database schema diagram, DDL scripts, and reference table population scripts are also included in this deliverable.
Milestones
<Sample>
10% Mar. 13 The construction of the application will be divided into three releases, each with a corresponding due date, or milestone. The proposal will specify which scenarios will be incorporated into each release, and the student is expected to implement these scenarios by the milestone due date. Deviations from the proposal's release schedule must be documented and accounted for in subsequent releases.
10% Mar. 27
10% Apr. 10
Final Project Submission 5% Apr. 17 The final submission consists of a postmortem report that describes the final state of the project and suggests recommendations for future projects.
Total Term Weight: 50%  
Top of Page Font Size: Increase Decrease Reset Instructor's Site ©2003