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).
- In step 8 you need to convert your EER diagram into tables. Make sure that you follow the procedure described in chapter 9.
- Implement the rules in chapter 9 for determining whether a table conforms to the first, second, or third normal form.
- Normalize tables that are not in the 3rd normal form.
- Make sure that all your tables are normalized (each table should be in the 3rd normal form).
- You should submit a list of all your tables, the attributes in each table and primary and foreign keys for each table.
- You must show all the steps in the normalization process.