Sales Orders Expiration: 3/30/2018 Order # Date Amount Customer# Customer Name 1 3/1/2018 $154.54 1 J's Salon Address 234 34th St Phone 555-234-0923 2 3/5/2018 $233.98 2 Beauty Parlor Inc. 98 Main St. 555-222-3333 3 3/8/2018 $516.34 3 Easy Styles 20 Main St. 555-989-5456 4 3/12/2018 $99.99 1 J's Salon 234 34th St 555-234-0923 5 3/30/2018 $108.54 1 J's Salon 234 34th St 555-234-0923 For questions 9-12, imagine that the table above represents a transaction file ready for batch processing. 9. Thinking about the first line of this file (indicated by the arrow), how would the "Payroll Process" treat this file? A. The file would be processed only on March 30, 2018 B. The file would be processed only before March 30, 2018 C. The file would not be processed D. The file would be used for batch totals 10. What is the hash total for Customer Number? A. 1 B. 3 C. 10 D. 8 11. The batch total calculated prior to processing is 5. The batch total calculated during processing is 6. Which of the following is the best explanation for this difference? A. The file was processed after the expiration date. B. All records were processed, but the hash total was incorrect. C. One record was processed twice. D. One record was skipped during processing. 12. The company currently has only 3 customers. A clerk enters a sales order and enters "4" into the Customer # field. What type of control would best prevent this data entry? A. Validity Check B. Limit Check C. Size Check D. Range Check For questions 13-16, imagine the same Sales Order table above represents a single data table in the company AIS. 13. What is the primary key of this table? A. Date B. Customer# C. Order# D. There is no primary key 14. In a properly designed relational database, how many tables would be used to store Sales Order data, including information about items ordered and information about the customer? Assume that customers can order more than one item with each order. Hint: This is the data structure we used in the Access lab and throughout Chapter 4 exercises. A. 1 B. 2 C. 3 D. 4 15. In this database, "Date" is a(n): A. Attribute B. Entity C. Record D. File 16. All the information stored about Order #1 is a(n): A. Attribute B. File C. Entity D. Record 3

Sales Orders Expiration: 3/30/2018 Order # Date Amount Customer# Customer Name 1 3/1/2018 $154.54 1 J's Salon Address 234 34th St Phone 555-234-0923 2 3/5/2018 $233.98 2 Beauty Parlor Inc. 98 Main St. 555-222-3333 3 3/8/2018 $516.34 3 Easy Styles 20 Main St. 555-989-5456 4 3/12/2018 $99.99 1 J's Salon 234 34th St 555-234-0923 5 3/30/2018 $108.54 1 J's Salon 234 34th St 555-234-0923 For questions 9-12, imagine that the table above represents a transaction file ready for batch processing. 9. Thinking about the first line of this file (indicated by the arrow), how would the "Payroll Process" treat this file? A. The file would be processed only on March 30, 2018 B. The file would be processed only before March 30, 2018 C. The file would not be processed D. The file would be used for batch totals 10. What is the hash total for Customer Number? A. 1 B. 3 C. 10 D. 8 11. The batch total calculated prior to processing is 5. The batch total calculated during processing is 6. Which of the following is the best explanation for this difference? A. The file was processed after the expiration date. B. All records were processed, but the hash total was incorrect. C. One record was processed twice. D. One record was skipped during processing. 12. The company currently has only 3 customers. A clerk enters a sales order and enters "4" into the Customer # field. What type of control would best prevent this data entry? A. Validity Check B. Limit Check C. Size Check D. Range Check For questions 13-16, imagine the same Sales Order table above represents a single data table in the company AIS. 13. What is the primary key of this table? A. Date B. Customer# C. Order# D. There is no primary key 14. In a properly designed relational database, how many tables would be used to store Sales Order data, including information about items ordered and information about the customer? Assume that customers can order more than one item with each order. Hint: This is the data structure we used in the Access lab and throughout Chapter 4 exercises. A. 1 B. 2 C. 3 D. 4 15. In this database, "Date" is a(n): A. Attribute B. Entity C. Record D. File 16. All the information stored about Order #1 is a(n): A. Attribute B. File C. Entity D. Record 3

Quickbooks Online Accounting

3rd Edition

ISBN:9780357391693

Author:Owen

Publisher:Owen

Chapter5: Operating Activities: Purchases And Cash Payments

Section: Chapter Questions

Problem 4.9C

See similar textbooks