Project Phase I
Goal:
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 January 15th, you will send us your schema and
data. In the second part, due January 29th, 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.
Application domains
We will provide three domains for your application:
Details:
In each of the domains, you will get a description of what the
database should store. Certain aspects of the domain will be
mandatory. 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.
How do I know which domain to implement? We will assign a
number between 1 and 3 for every student in the class. You will
implement the corresponding domain number.
What and When Do I hand in?
- On January 15th, you need to email to the TA's an XML
file with the schema and the data of your application. See here how to send the database in XML.
- On January 27th, you need to email
the URL of the web front end to the application.