Kims Flowers Expenditure Cycle Requirements: 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.
Kim's Flowers, Expenditure ERD Purchasing Agent prp. DY Purchase Order TO Kim reitt Vendor Flowers hon Floral Receipts bo Floral Designer Accounts Payable Clerk Cash NA Cash Payments TORS Kim Sot Vendor Flowers OF Flower Disposal Kim Kim's Flowers Expenditure DFD Recording Purchasing Agent purchase info purchasing agents Kim Vendors Purchase Order Flowers purchase Orders Vendor Packing Slip Cash Floral Receipt Floral Receipts Kim Floral Designers items received Cash Payment AP Clerk payment Floral Designer info A/P Clerk Vendor cash payments Kim Flowers Disposal flowers to disp. Kim Disposal Kim's Flowers Expenditure DFD Reporting and Maintenance Purchase Orders Kim ta orders to print Kim Print Purchase Orders Purchasing Agent purchase order Vendor Flowers Vendor checks Cash Payments Kim _checks to print Print Checks Cash Flowers con Kim Maintain inventory items changes to items Kim Partial List of Entity Attributes (does not include attributes which are characteristic of relationships with other entities) Floral Inv (Item No. Description, QOH, ListPrice) CashAccounts (AccountNo. Bank, Type. DateStarted, Balance) APClerk (APClerk#, EmployeeName, DateStarted, Address, Phone#) Purchase Agent (Purchase Agent #, EmployeeName, DateStarted, Address, Phone#) FloralDesigner (Designer #. EmployeeName, DateStarted, Address, Phone#) Kim Kim. Employee Name, DateStarted, Address, Phone#) Vendor (VendorNO, VendorName, Address, Phone# Balance,) PurchaseOrders (PONo, Date,) Floral Receipt (ReceiptNo, Date) Payment (VoucherNO. Date, Amount CheckNO) FlowerDisposal (DisposalNO, Date. QtyDisposed, Reason) Kim's Flowers, Expenditure ERD Purchasing Agent prp. DY Purchase Order TO Kim reitt Vendor Flowers hon Floral Receipts bo Floral Designer Accounts Payable Clerk Cash NA Cash Payments TORS Kim Sot Vendor Flowers OF Flower Disposal Kim Kim's Flowers Expenditure DFD Recording Purchasing Agent purchase info purchasing agents Kim Vendors Purchase Order Flowers purchase Orders Vendor Packing Slip Cash Floral Receipt Floral Receipts Kim Floral Designers items received Cash Payment AP Clerk payment Floral Designer info A/P Clerk Vendor cash payments Kim Flowers Disposal flowers to disp. Kim Disposal Kim's Flowers Expenditure DFD Reporting and Maintenance Purchase Orders Kim ta orders to print Kim Print Purchase Orders Purchasing Agent purchase order Vendor Flowers Vendor checks Cash Payments Kim _checks to print Print Checks Cash Flowers con Kim Maintain inventory items changes to items Kim Partial List of Entity Attributes (does not include attributes which are characteristic of relationships with other entities) Floral Inv (Item No. Description, QOH, ListPrice) CashAccounts (AccountNo. Bank, Type. DateStarted, Balance) APClerk (APClerk#, EmployeeName, DateStarted, Address, Phone#) Purchase Agent (Purchase Agent #, EmployeeName, DateStarted, Address, Phone#) FloralDesigner (Designer #. EmployeeName, DateStarted, Address, Phone#) Kim Kim. Employee Name, DateStarted, Address, Phone#) Vendor (VendorNO, VendorName, Address, Phone# Balance,) PurchaseOrders (PONo, Date,) Floral Receipt (ReceiptNo, Date) Payment (VoucherNO. Date, Amount CheckNO) FlowerDisposal (DisposalNO, Date. QtyDisposed, Reason)
