Posted: November 11th, 2015

Project Stage 2 Kim’s Flowers Expenditure Cycle

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 3^rd normal form.
4. Make sure that all your tables are normalized (each table should be in the 3^rd 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.