ACCT 3122 ACCOUNTING INFORMATION SYSTEMS MCGRAW-HILL COURSE PROJECT QUESTIONS WELL ANSWERED LATEST UPDATE 2026

ACCT 3122 ACCOUNTING INFORMATION SYSTEMS MCGRAW-HILL COURSE PROJECT QUESTIONS WELL ANSWERED LATEST UPDATE 2026 *Section 1* In the above diagram, the correct name of the class designated with the letter A is which of the following? - Answers Customers In the above diagram, the correct name of the class designated with the letter B is which of the following? - Answers Cash Receipts In the above diagram, the correct name of the class designated with the letter C is which of the following? - Answers Stores In the above diagram, the correct name of the class designated with the letter D is which of the following? - Answers Flower Inventory In the above diagram, the correct name of the class designated with the letter E is which of the following? - Answers Payroll In the above diagram, the correct name of the class designated with the letter F is which of the following? - Answers Purchases of Flowers In the above diagram, the correct name of the class designated with the letter G is which of the following? - Answers Vendors miscellaneous In the above diagram, the correct multiplicities designated with the number 1 is which of the following? - Answers 1..1 In the above diagram, the correct multiplicities designated with the number 2 is which of the following? - Answers 0..* In the above diagram, the correct multiplicities designated with the number 3 is which of the following? - Answers 1..1 In the above diagram, the correct multiplicities designated with the number 4 is which of the following? - Answers 0..1 In the above diagram, the correct multiplicities designated with the number 5 is which of the following? - Answers 1..1 In the above diagram, the correct multiplicities designated with the number 6 is which of the following? - Answers 0..* In the above diagram, the correct multiplicities designated with the number 7 is which of the following? - Answers 1..* In the above diagram, the correct multiplicities designated with the number 8 is which of the following? - Answers 0..* In the above diagram, the correct multiplicities designated with the number 9 is which of the following? - Answers 0..* In the above diagram, the correct multiplicities designated with the number 10 is which of the following? - Answers 1..1 In the above diagram, the correct multiplicities designated with the number 11 is which of the following? - Answers 0..* *Section 2* Review the Excel data, prepare the UML class diagram (REA) for Y Not Flowers and then choose the correct fields to complete the Y Not Flowers table listing below: - Answers 1. retail price 2. store location 3. annual depreciation 4. check# 5. store# 6. store# 7. receipt amount 8. order# 9. sale date 10. store# 11. check# 12. check date 13. none of these 14. check# 15. account# 16. timecard# 17. store# 18. (FK) 19. store# 20. (FK) 21. order# + Inventory# 22. none of these Move the Excel data to Microsoft Access and prepare queries to answer the following questions: Required: Join the Orders and Sales table with the Orders and Sales Items table. Include the following fields in the query: order#, order_date, customer#, order_emp#, sale_date, truck_vin, cash_receipt#, store#, inventory#, qty_ordered, qty_sold, sale_price. Limit sales to the first quarter of 2022 beginning on January 1 and ending on March 31, by entering BETWEEN #1/1/2022# AND #3/31/2022# for the sale_date field in the Criteria row of the query by example grid. How many records are there in your query? - Answers 2,636 Section 3, Question 2 Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Required: Continue with the same query; return to design view. Create a new field called item amount to calculate the sale amount for each item by multiplying quantity sold (qty_sold) times sale price (sale_price). Return to datasheet view, select Home Records Totals to add the total row to datasheet view. What is the sum of values in the item amount field? (Round your answer to 2 decimal places.) - Answers $2,105,610.50 Required: