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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please help.
Don't use any
It's strictly prohibited.
Otherwise I will report to the solution.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education