Computer Science 455
Exercise #4
Due: Friday, April 2
Continue the bottom-up design exercise started in class before the break.
- Identify 2NF violations (if any) and resolve. Do not do too much (i.e.,
don’t also resolve 3NF problems)
- Identify and resolve 3NF problems
- Turn in
- Un-normalized list of fields (from in-class part)
- List of functional dependencies (from in-class part)
- Identify and resolve 1NF problems (from in-class part)
- Identify and resolve 2NF problems (with resulting relational schema)
- Identify and resolve 3NF problems (with resulting relational schema)
- Final relational schema
- Final entity-relationship diagram.
Working on this in the groups assigned for the first part of this exercise
is preferred. In that case, each group should turn in one copy with the names
of the individuals in the group. No email attachments (sorry).