Database Systems

CS-377: Spring 2004

Project Model

DATABASE MODEL MILESTONE:

Sub-milestone deadline: Thursday, February 19 at 11:59pm, on paper

Overall milestone deadline: Friday, February 27th, in class, turn in your project notebook

NOTE: you still should not be mentioning tables or relations at this point at all.

Sub-milestone:

	Turned in on-paper by 11:59 pm on Thursday, February 19th
	Turn in a draft database model-so-far. These will be used in a lab exercise where you get to review several classmates' models.

Overall milestone:

Turn in your project notebook, which now contains the following:

After the proposal divider:

	your revised proposal, if required, clearly marked with a Last modified: date,
	your original proposal, including my comments and annotations

The second divider should be neatly labeled, on its tab, as model.

	after that divider should be your dated database model (hopefully polished/improved from the sub-milestone version), expressed as an entity-relationship diagrams. These may be neatly hand-drawn or computer-drawn.
	(however, if they are hand-drawn, you are required keep a photocopy of them, in addition to the original turned in --- just in case!)
	In addition to the diagram, include an enumeration of attributes, grouped by entity-set or relationship-set, with a description of the domain for the values of the attribute and a b4rief description of the use of the attribute.
	Diagrams should conform to the notation presented in the textbook. In addition, I would like Indications of both minimum and maximum cardinality in relationships.

Your models need to show if you are meeting the minimum requirements, in terms of number of entities/objects and kinds of relationships, mentioned in the proposal milestone section. In particular, remember that a superclass entity/object and all of its subclass entities/objects count as one significant entity/object, all together.

Remember: entities/objects are NOT tables or relations. Do not refer to them as such, or include information about tables/relations in this section. The project is not at the table/relation stage yet!

Also remember: if the previous milestone required that certain changes or additions be made, they must be included here, or this milestone's grade may be affected.

Home | Syllabus | Schedule | Projects | Contact Information

All rights reserved, Thomas C. Bressoud and Denison University.
For problems or questions regarding this web contact bressoud@denison.edu.
Last updated: 01/30/04.