The phases of the project include choosing an application area, deciding what functionality to provide (over-and-above basic SQL access), modeling the data in an E/R diagram, translating this into a relational schema in SQL Server (taking into account normal forms and constraints), populating the relations, and linking the database to a web-based front end that can carry out some of the application's functionality. When you're all done, you will demo the project for Scott and Bart. This will involve all group members meeting with us and showing us the application and executing some SQL queries directly.
The project is broken down into several phases with their own deadlines; these deadlines will not be extended. Follow the links for specific descriptions of each phase of the project:
Note that you are free to work ahead of this schedule: you will know the relevant material in time to complete many of these phases early, and if you submit Phase II or Phase III early, we will do our best to evaluate it and return it to you quickly so you can get going on the next phase.
The grade for the project is determined as follows: