ADB Assignment 2

Views and Normalization

Overview

In your small group, identify a data problem you would like to solve. It should be a reasonably substantial problem that you anticipate will involve several views and entities. Choose carefully, because you will be working on this problem throughout the semester. All results will be posted on a group web page for examination by instructors and other groups.

Group information

Please provide the following information about your group:

Narrative of problem

Present a narrative of the data problem you are trying to solve. Describe as succinctly as possible the broad purpose of the database, who it is for, how it will be used, how it might be delivered (web based, lan, personal computers, mainframe?) Anticipate how many users you will have, and whether you will have concurrent users.

View List

Generate a list of views that describe how you anticipate the user(s) will interact with the database. This can be done with any tools you wish, but a painting program would probably be the easiest.

E/R Diagram

Generate an Entity / Relationship diagram for the major entities in your database. You may use the format in your book, the one presented in lecture, or some other documented form. Be sure to provide an index if you use any non-standard symbols. At a minimum, the E/R diagram should indicate the tables used, the primary key of each table, relationship indicators, and 1/1, 1/many, many/many indicators. If you wish, you can use a tool such as Access' relationship builder to generate the diagram, but the results must be viewable on the group web page, so you may need to convert it to a gif or something.

Submission

Please submit the URL of your group page by email to Andy (aharris@cs.iupui.edu) and Simon (xwang@cs.iupui.edu). This project is due by May 29.
© Andy Harris
Indiana University / Purdue University, Indianapolis
email: aharris@cs.iupui.edu
homepage: http://www.cs.iupui.edu/~aharris