1. From the descriptions regarding the revenue cycle and expenditure cycle for this company, Conputrr Warehouse, please use the information to draw an Integrated REA Diagram for both cycles and complete their cardinalities accordingly.

2. Develop a set of tables to implement the integrated REA diagram you developed from (1) for computer warehouse in a relational database. Specify a primary key for each table and suggest appropriate (at least two) other attributes that should be included in each table (some tables have foreign jets but some dont)

Revenue Cycle: The Computer Warehouse sells computer hardware, software, and supplies (ex: papers). Individual customer just walks into store, select merchandise, and must pay for their purchase in full before leaving the store. Corporate customers, however, call in orders in advance, so that the item to be picked up. Corporate customers may charge their purchase to their account. The Comp s are waiting uter ouse mails corporate customers monthly statement that summarize all purchase made the prior onth. Corporate customers pay the entire balance, as listed on the monthly statement, with one check or EFT transaction Expenditure Cycle: The Computer Warehouse purchases its inventory from more than a dozen different vendors. Orders are placed via telephone, fax, or on the supplier's Website. Most orders are delivered the next day. Most orders are filled completely in one shipment, but sometimes a supplier is out of stock of a particular item. In such situations, the bulk of the order is shipped immediately and the out of stock item is shipped separately as soon as it arrives (such shipments of back orders are never combined with any new orders placed by Computer Warehouse). The Computer Warehouse pays for some of its purchases COD but usually pays by the 10th of the month for all purchases made the prior month. None of its suppliers allow it to make installment payments. Required: (1) From the descriptions above regarding the revenue cycle and expenditure cycle for this company Computer Warehouse, please use the information to draw an Integrated REA Diagram for both cycles and complete their cardinalities accordingly (2)Develop a set of tables to implement the integrated REA diagram you developed from (1) for Computer Warehouse in a relational database. Specify a primary key for each table and suggest appropriate (at least one) other atributes that should be included in each table (some tables have foreign keys but some don't) Ex: Other attributes (FK in italics) Table XXx Primary Key