CMSC 10200: Lab 4

Wednesday, July 13, 2005

<-- back


This week's exercise: a database-driven website.


Step 1

Sketch a model of your database. Consider all possible relationships between tables and determine their kind. Note any non-trivial simplifying assumptions you make along the way.

For each table in your database model, make a text file containing its CREATE TABLE query.

Create the tables by following the instructions given in lab.

Step 2

Spend some time gathering data for each table in your database. Make sure that each table contains some information. This will allow you to provide a (potentially) complete framework for your website, even though most of the data may be yet to come.


Step 3

Make a web interface for your database. The interface should include whatever elements you feel might be desirable to a user of your database. You are encouraged to use stylesheets, user-friendly forms, and whatever other tools you can think of to make your site more attractive and interesting.

To submit this lab, simply provide a link to your website from your CS home page.