CIT 381 Database Systems, Fall 2007

Final Project

For the final project you will design and implement a database for a workshop proposal/speaker/review process. Ideally, you will work in a group of size two. Groups of size one and three are also possible, but please check with the instructor. All members of the group will receive the same grade.

There are four basic steps for you to undertake

1. Model the problem using ER Studio.
   You will be asked to turn in a preliminary design on Nov. 8.

2. Implement the model in MySQL.
   As in the lab, convert your ER Studio model to an MySQL database. Alternatively, you can do it directly in MySQL, such as by using the MySQL Browser.

3. Populate your database
   Here are some sample data items. Please add some additional data, which should span several years.

4. Think of a number of operations
   Description of the queries. Think of the SQL queriies that would be needed to answer these.

5. Build your web pages using PHP
   Incorporate your operations from the previous step into web pages that use PHP to connect to your database, execute the SQL, and display the results.

WHAT TO TURN IN ON NOV 8

A hardcopy (preferably, or email) of your ER Studio design. You may optionally include a pdf document discussing/explaining your design, and perhaps asking questions.

WHAT TO TURN IN ON DEC 7

Please write a short (1-page maximum) report summarizing your project. Include at least the following plus whatever else you want us to know:

• names of all group memebers
• each person's main contributions
• links to each part of the project: model, database, website homepage
• the major lessons learned during this project
• each person's "signature" which indicates that you have read and agree to everything written in the report, unless otherwise noted if you disagree with something

Here is a sample (fictional) report. You are free to use the Word document as a template but, as usual, you need to make it into a PDF before you email it.

Assign one person to e-mail your final report to Paea (paea@cs.uoregon.edu), Prof. Wilson (cwilson@cs.uoregon.edu) and each of the group members as well. In the subject line please put: "CIT 381 Final Project Report". In the body of the e-mail, please list (again) the names of each group member and any final comments you may have.

NEED A PARTNER?

Send me email and, as much as possible, I will try to match people up.