The Phase I Report must contain an analysis of the intended information
system and the purpose of this phase of the project. It must describe the
problems encountered in this phase and justify the solutions. It must contain
all documentation produced in this phase.
The Phase I Report will be graded out of 20 points total, counting
as 20% of your final project grade.
Specifically, the following is expected:
1. (10 points) Analyze the entire application for the Allegro Music Store and come up with an extended ER diagram. Use the notation from Chapter 3 in the book and additional notation for generalization hierarchies from Chapter 4.
- include max cardinalities
only
- show all attributes
- use some diagram editor
to draw a clean diagram (handdrawn diagrams are accepted if drawn with
rulers neatly.)
2. (2 points) Make a list of semantic constraints that apply over and above what you can show in the diagram.
3. (2 points) Mention any assumptions you made in doing the above that go beyond what is given in the project description.
4. (5 points) Make a list of application areas: e.g., order processing, billing, vendor orders, inventory management etc. (NOTE: as we said, not all of these are for implementation in phases 2 and 3, but you should list all areas for Phase 1.).
For each area - list what input documents are involved (just state contents of the document), what outputs are produced (state contents in terms of attributes) and what database activity is involved (retrievals and updates).
5. (1 point) Besides the above, comment on the difficulties you
faced in doing this conceptual design task.
NOTE: The above specification will drive your subsequent phases.
As in any actual design and implementation, you will be revising what you
do here as you proceed thru the phases. Please be explicit and detailed
when writing your report. This will help you in the long run!
Any questions/concerns should be addressed to me or to the newsgroup:
cat@cc.gatech.edu -or-
news:git.cc.class.cs4400a