Clarification of deliverables due on Tuesday, March 21, 2006

Each group received descriptions of four (4) different database needs:

1. Beta University Annual Fund
2. Pleasantville Community Theatre Group
3. Friendly Cars Dealership
4. Images Photograph Studio

Individual Sequential Process

1. Each group member was to start analyzing a different project and to indicate in writing (on the computer) as many of the components shown below as possible.

2. Then they would pass their analysis and the description on to another group member who would indicate additions and/or modifications

3. Step 2 was to be repeated until everyone had seen each of the projects

Group Process

The group was to meet at make a final group decision for each of the projects after discussing alternatives.

Components (similar to what you did for Lab 3 – the Art Gallery project with additions)

NOTE: The answers to Lab 3 are available under course documents on Blackboard.

1. What are the entities in the project?
2. What are the attributes for each entity?

NOTE: sketching screens may prove helpful in deciding what the attributes are

3. What are the input documents?
4. What are the reports to be produced?
5. What are the initial assumptions for the project?
6. Either E-R diagrams or Semantic Object models for each project

NOTE: at least one of each is required

Deliverables

1. The group decision as to each of the components (clearly labeled as such)

NOTE: sketching screens may prove helpful in deciding what the attributes are

2. The individual work of each group member (clearly labeled as such)

NOTE: If all of the individual work for a given project is on a single sheet, then use

different color highlighters to indicate who did each part.

Tuesday’s class

• We will talk about how to construct and use a data dictionary (from another text).

NOTE: Professor Harris talked about this in her lecture

• We will also continue discussion of semantic object models (Appendix E in our text).