Forgot your password?
Document Actions
hw2.htm
CS 311: Databases
E/R Diagram for your Project
(Homework 2)
due on Monday, Feb 27
This is the first of five assignments for our semester-long project. Be careful with this one because you are setting the parameters for all of the future parts of the project.
In choosing a domain for your project, here are a few things you should keep in mind:
-
There should be some complexity to the data. Aim for a minimum of 5 Entity Sets, with relations between them.
- You should be able to either find or make up data for your database. Inventing a large amout of related data isn't as easy as it sounds, so think about if if that is what you plan to do.
- There should be a variety of natural queries about your data and how the various sets of data are related.
- You are goiing to spend all semester with this domain, so it should be something that you are interested in.
For this assignment I want you to hand in a cover page and an E/R diagram. The cover page should contain the following information:
-
A descriptive title for the database
-
Who is working on it. All projects must be done by 1 or 2 people. All of the later assignments should be done by the same people as this one. I want one submission per project -- if you work with a partner, the two of you jointly submit one copy of the assignment. Except in extraordinary circumstances, you will both receive the same grade for the project assignments.
-
A paragraph or two describing the data in English. What are the major pieces of data and how are they related? Where will you get the actual data for your database. (It is okay to invent data, but I would like to know that this is what you are doing.) What are natural queries for this data?
The rest of the assignment consists of an E/R diagram for your domain of knowledge. Use the conventions from the class and the text: underline key attributes, double lines for weak entity sets, triangles for isa relationships, arrow heads to indicate multiplicity of relationships, etc.
I will keep a copy of this assignment and expect your subsequent assignments to be consistent with it, so put some thought into the way you do this.