Project Phase I
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 Oct 15, you will create your database schema, your actual database on the SQL server, and some sample data tuples. In the second part, due Oct 25, you will implement the query
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 10 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
What and When and How Do I hand in?
- Part 1: Schema + database + data
What - your complete schema, in a .txt file, clearly stating your tables, columns, datatypes of columns, keys and foreign keys etc. Also in a .txt, turn in the data you've created (results of SELECT * FROM each of your tables).
When - On or before October 15th.
How - email your files to victort@cs.
- Part 2:
What - A .zip file that contains all of your project code (.aspx, .cs) plus a file
named "README.txt" that contains the url of your web application. Please do not edit your project
after you turn it in. We may need to look at the timestamps to verify
timeliness, correctness, etc.
When - On or before October 25th.
How - Create a subfolder named "turnin" under your network share on iisqlsrv (e.g. \\iisqlsrv\<your_id>\turnin) and put everything in it.