Project Information

Project Description

Students in teams of 4 are required to select an application that would benefit from a database and build a database application from start to finish.

Philosophy

Building a full database application from scratch allows you to control the process; instead of having the pieces decided for you, you must make all of the decisions by yourself. Part of this process is that you will see how design decisions made at the beginning will effect your final project. We'll have some practice of some of the skills that you'll need in tutorial, but this will allow you to get some more in depth practice and a feel for what it's like when you make all of the decisions for an application.

Goals

Deciding on an application are for which database systems would be required
Modelling the domain of the application, and defining the application functionalities
Designing and implementing the schema
Populating the database (this should not be the main focus of the project)
Writing the code needed to embed the database system in an application that has a Graphical User Interface (GUI).

PhP and JDBC help

PhP help and JDBC help can be found on the tutorials page

Schedule

There are a number of intermediate deadlines that you must meet in order to ensure a successful project. Descriptions for each of the required checkpoints will be described on separate pages. To get an idea of an appropriately sized project, the one from a previous term is about right.

The cover page to be turned in with all assignments.

Sep 27: Project proposals due (10% of the project grade, marking scheme)
Oct 18: Formal specification due (10% of the project grade, marking scheme)
Nov 15: Complete Project due (20% of the project grade)
Nov 29: Demos due (60% of the project grade)

Talking to the TAs vs. submitting to the directories

As mentioned in class, it is recommended that you go over your milestone with the TA in tutorial who is assigned to look at projects, and the TA can give you feedback or answer your questions. You may also also talk to the TA who would be marking your project during their office hours. It is recommended to talk to the same TA throughout the term, but it is not required.