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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please help.

Don't use any AI.

It's strictly prohibited.

Otherwise I will report to the solution.

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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education