For Stage 1 (already completed) here is K Cannon Inc.'s explanation:

K Cannon, Inc., is a manufacturer of portable MP3 players. The company purchases raw materials such as plastics and computer chips for its conversion cycle. The following describes K Cannons purchases and payment procedures.

John, the purchasing department clerk, monitors raw material inventory levels and prepares purchase requisitions when purchases are necessary. Purchase requisitions are sent to the purchasing agent, who prepares six copies of a purchase order. Two copies are sent directly to the vendor. One is placed in an open purchase order file in the purchasing department, and one is used to post to the purchases journal. Each week, the purchasing department clerk prepares a journal voucher from the purchase journal and sends it to the general ledger department for posting.

Upon receiving the raw materials, the receiving department clerk creates five copies of the receiving report. One copy is sent to the AP department. Two copies are sent to the purchasing department, where one is filed and one is used to update the inventory records. The final copy is filed in the receiving department with the purchase order and packing slip. Suppliers send their invoices to the AP department, where they are used to update the AP subsidiary ledger.

In the cash disbursements department, Larry receives the information from the AP department, such as the purchase requisition, purchase order, receiving report, and invoice. He then prepares and signs the checks for the suppliers. After preparation of the checks, the supporting documents are sent back to the AP department. Each week, Larry prepares a journal voucher and sends it to the general ledger department for posting.

Requirements:

The second stage of the project requires students to develop a set of tables to implement the REA diagram in a relational database.

Examine the first stage solution for K Cannon, Inc.s purchase cycle. Use the provided solution (REA Diagram posted as the picture above) as a starting point for this stage.

Create the MS Access tables on the basis of the tables you developed. In each table, define the primary key and foreign keys. For each attribute, define the data type, provide a field description, and define the field properties.

Populate your tables with fictitious data entries; you should sufficiently populate your tables so that you can demonstrate your design (about 20 rows for events and 10 for agents and resources).

Establish relationships between all the tables you created (based on your design). Make sure that you enforce the referential integrity in all your relationships.

Write queries needed to answer the following questions.

a. Who are Cash Disbursement Clerk in K Cannon?

b. How many different kinds of inventory items does K Cannon hold?

c. What was the total purchase amount?

d. What was the average purchase amount?

e. To which supplier K Cannon placed the most purchase order (display supplier name)?

f. To which supplier K Cannon paid the largest amount of cash?

g. What is the difference between quantity received and quantity ordered for each inventory item?

FIGURE 13-1 Context Diagram of the Expenditure Cycle Goods and services Revenue cycle Invoices Suppliers urchave Expenditure Purchase orders cydlechone need Various and cycle 379 FIGURE 13-1 Context Diagram of the Expenditure Cycle Goods and services Revenue cycle Invoices Suppliers urchave Expenditure Purchase orders cydlechone need Various and cycle 379