Document is attached , I will not accept it after deadline time Accounting Information System

Group Project - Part II Tica's Flower Inc. Purchasing (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). Examine the standard partial solution for Tica's Flower Inc. Use the provided partial solution as a starting point for this stage. Convert the REA 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. In addition, you must show all the steps in the normalization process. Deliverable: Complete the document (i.e., TeamNumber-Part2.docx). Submit one file. Be sure to change the file name using your team number. For example, my MS file would be \"Team10-Part2.docx.\" 1 REA Diagram 2 Partial List of Attributes for Each Entity Entity Attributes Flower Inventory ItemNo, Description, QtyOnHand, ListPrice Vendor VendorNo, VendorName, VendorAddress, Balance Employee EmployeeNo, EmployeeName, EmployeeAddress, DateStarted, JobTitle, Phone Cash AccountNo, AccountType, Bank, AccountBalance Purchase Order PONo, PODate Receive Order ReceiptNo, ReceiptDate Make Payment PaymentNo, PaymentDate, PaymentAmount Flower Inventory - Purchase Order QtyOrdered, OrderPrice Flower Inventory - Receive Order ItemCondition Purchase Order - Receive Order QtyReceived Note: The list does not include attributes (i.e., foreign keys) which are characteristic of relationships with other entities. 3