Project Phase I

Due October 27, 2003 (Extended !)

In this phase you will build a complete database application using SQL Server with a very simple web-based front end. You will be given a high-level specification of the domain of the database application, and which queries your interface needs to support. This phase will be done in two parts. In the first part, due October 17th, you will send us your schema and data. In the second part, due October 27th (extended !), you will implement the database and the query interface.

Data

Although you are required to populate your database with sample data, we expect that to be a small part of your work. We expect that each table in your database will contain roughly 20-30 tuples.

Description

In each of the domains, you will get a description of what the database should store. Certain aspects of the domain will bem andatory. In addition, you are expected to invent a few other attributes of interest to model in your database. The description of the domain will be given informally, and you will need to prepare a database schema that models the domain.

Your schema should have at the least four tables, but can be much larger. Some of the tables will have five columns or more. There can be foreign keys between columns in different tables. Each column must have a data-type and declared to be either a key or not a key. Choose imaginative column and table names.

Turnin Procedure

• On October 17th, you need to email to the TAs an XML file with the schema and the data of your application.
• On October 27th (extended !), you need to email the URL of the web front end to the application. Send this to tessa@cs with the subject 'PhaseI Turnin'.
  You'll also need to turn in you code using this unix turnin command:

  turnin -c cse444 -p phaseI [.cs file1] [.cs file2] [...]