Project Stage 2
Kim’s Flowers Expenditure Cycle
Requirements:
The second stage of the project requires students to perform step 8 in the event-oriented
modeling (as described in chapters 8 and 9).
1. In step 8 you need to convert your EER diagram into tables. Make sure that you
follow the procedure described in chapter 9.
2. Implement the rules in chapter 9 for determining whether a table conforms to the
first, second, or third normal form.
3. Normalize tables that are not in the 3rd normal form.
4. Make sure that all your tables are normalized (each table should be in the 3rd
normal form).
5. You should submit a list of all your tables, the attributes in each table and primary
and foreign keys for each table.
6. You must show all the steps in the normalization process.
1
