The second stage requires you to perform step 8 in the event-oriented modeling (as described in chapters 8 and 9).

1. Examine the standard partial solution for Kim Flowers you will find in the Course Documents section of the Blackboard site. Use the provided partial solution as a starting point for this stage.

2. In step 8 you need to convert your EER diagram into tables. Make sure that you follow the procedure described in chapter 9.

3. Implement the rules in chapter 9 for determining whether a table conforms to the first, second, or third normal form.

4. Normalize tables that are not in the 3rd normal form.

5. Make sure that all your tables are normalized (each table should be in the 3rd normal form).

6. You should submit a list of all your tables, the attributes in each table and primary and foreign keys for each table.

7. You must show all the steps in the normalization process.

  

Transcribed Image Text:

Flowers Cash Flowers Kim's Flowers, Expenditure ERD Mor br 8 Dr Purchase Order Floral Receipts o Cash Payments Flower Disposal pmp by proses restb fon TIRNO by la ter Expres seatt Recond Purchasing Agent Kim Vendor Floral Designer Accounts Payable Clerk Kim Vendor Kim Flowers Cash Flowers Kim's Flowers, Expenditure ERD Mor br 8 Dr Purchase Order Floral Receipts o Cash Payments Flower Disposal pmp by proses restb fon TIRNO by la ter Expres seatt Recond Purchasing Agent Kim Vendor Floral Designer Accounts Payable Clerk Kim Vendor Kim

Answer rating: 100% (QA)

inventory Items Cash GoodsReceipt 406 Inventorytems 800 801 802 803 805 Employees 208 ... View the full answer