I would like to request help for thisGroup Project Part II Kims Flower Inc. Purchasing (Expenditure) Cycle. Attached is the instructions for this assignment.

Group Project - Part II Kim'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 Kim'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 complete the attached table describing the list of all your tables, the attributes in each table, and primary and foreign keys for each table. In addition, you must summarize all the steps that you sued in the normalization process. Example: When the diagram was converted into a table form this already made all of the tables into the second normal form. At this point then the only thing that needs to occur to make all of the tables into third normal form is to remove all transitive dependencies that may be still in the tables...... 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 ERA 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