Dan Tragg insists on using only the highest quality blanks in the manufacturing of his surfboards. Traggs uses a list of approved vendors with whom they have established a good relationship over the years.

The blanks are purchased when a production supervisor recognizes a need for inventory. The supervisor goes to his or her terminal and completes a Purchase Order Form online. This is done by selecting the vendor, the inventory item, and the amounts to be ordered. The order can be for one type of blank or for several types. The Purchase Order Form is reviewed by a Purchasing Agent. If it is approved, a Purchase Order Report is prepared, printed, and mailed to the selected vendor.

The goods are received and counted by the Receiving Clerk. The Receiving Clerk enters the date, the PO number, and the Vendors Invoice Number in the top portion of the form. In addition, the Clerk must enter the Inventory ID number and the quantity received in the form.

If the order is in agreement with the Purchase Order, it is scheduled for payment. Traggs sometimes pays for more than one invoice (receipt of inventory) with each check (cash disbursement). In addition, on occasion they have placed very large orders and have paid for those orders in installments.

You will apply the REA Model and use Microsoft Access software to complete the case analysis of the expenditure cycle described above.

Requirements

1. Identify the resources, events and agents (~ 5%)
2. Draw E-R diagrams that illustrate the relationships between these items. You for sure need additional assumptions - please make it clear in writing. (~ 40%)
3. Identify tables that you would need to create a working database. For each table, please include the following information: table name, primary key(s), foreign key(s), and other attributes. Your tables should be consistent with the E-R diagram you created in part 2. (~ 15%)
4. Using Access, create at least three records for each of the tables you identified in part 3. Document by printing the window from the Access. (~ 10%)
5. Create relationships for your various tables. Document by printing the relationships window make sure primary key icons appear on the relationships. Note that your relationships should be consistent with the E-R diagram you created in part 2. (~ 30%)

->I solved problem 1-3, but I do not know how to solve problem number 4 and 5. Can you tell me how to solve these two problems in detail? Also, I was trying to make tables following part 3, but I am not sure that it is correct or not, so can you check for me? I attached the picture of my activity.

Table Tool Group Project Access : Database-C\Users\EUN HYE SON Desktop Group Project Access accdb (Access 2016) - Access Sign in O 11 === = = r Save = = = . File Home Crate External Data Database Tools Help Table Fields Tahir Tell me what you want to do X Cut A Ascending Selection New Totals sh Replace Fen (Detail E Copy 2.1 Descending Acivanced Spelling Go To View Paste Filter Refresh Tind Format Painter Remove Sort y Toggle Filter All X Dalete - More Scie BIVA Views Sort & Filter Records Find All Access ... * The Toash This isbursement 3 ThiCashdisbursementtarciptofinventory Thlwertory Search Receipt Nu Disburseme. Amount Dis. Payment Dr. Description. Click to Add 0 WO Tables TolarClerk Test formelling 1 TbiCash THE TbiCash Disbursement I ... TiCahabusette Telinventory - TL TN TLCT t = 12cc.. THE receptoh.. THE Thieront Telpurchaseagent To purchascorder m Hn H - Tipurchasest TiRecepta inventoryto.. Thierove EiReceivegoods THE Teleceningdek This peniser TITE Vendor Record: 141 of 1 No Filter Search Dulastel View