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 posted to the Blackboard. Use the provided solution 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?

REA Diagram: Flags Item Processes Inventorv Order Product H Purchasing Clerk Receives Causes Ships Supplier Increases OReceive Product Prepares Receiving Duality Receives Supplier Cash Disbursement Clerk Decreases Processes Cash Disburse Cash REA Diagram: Flags Item Processes Inventorv Order Product H Purchasing Clerk Receives Causes Ships Supplier Increases OReceive Product Prepares Receiving Duality Receives Supplier Cash Disbursement Clerk Decreases Processes Cash Disburse Cash