Quick help question num 7 and 8

B 4G it 12% 2 3:31 PM 4 5915760341442103311 .pdf E b. 1:N d. M:N 7. Page 2 of 4 The following tables and attributes exist in a relational database: Table Attributes Vendor Vendor#, name, street address, city, state Purchases P.O.#, date, amount, vendor#, purchasing agent# Inventory Receipts P.O.# Receiving report#, date, receiving clerk#, remarks, Cash Disbursed Check#, date, amount Inventory Receipts - Cash Disbursed Check#, receiving report#, amount applied to invoice Draw an REA diagram for this database. State any additional assumptions you need to make about cardinalities. 8. Identify the attributes and develop relational database tables for the revenue cycle diagram below. Inventory Customer Order So Salesperson Customer Ship Goods Shipping Clerk Cash Receive Payment A/R Clerk 9. What internal control procedure(s) would provide protection against the following threats? a. Workers on the shipping dock steal goods, claiming that the inventory shortages reflect errors in the inventory records. b. An employee posts the sales amount to the wrong customer account because he incorrectly keys the customer account number into the system. c. An employee makes a credit sale to a customer who is already four months behind in making payments on his account. d. An employee authorizes a credit memo for a sales return when the goods were never actually returned. e. An employee writes off a customer's accounts receivable balance as uncollectible to conceal the theft of subsequent cash payments from that customer