Use the following (partial) tables to answer the required questions. Please note that the tables only include example rows of data, and there could be more attributes (columns) included in the tables. I have only shown the columns relevant to the case questions, and there would be thousands of rows in many of these tables. Sales Event Table Sales Event # Date Terms Salesperson ID Customer ID 1 11/5 2, 10 net 30 2 2543 2 11/5 2,10 net 30 4 635 3 11/5 COD 6 1845 Sale-Inventory Table Sale Event # Inventory Item # Inventory Quantity Price each 1 876 10 1.25 1 674 8 0.875 1 451 30 0.995 2 887 54 1.475 2 513 188 0.525 3 736 36 24.995 3 001 58 7.875 3 w 302 16 8.00 3 224 114 8.75