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

Hi, my name is Jennifer. I am having trouble with this same problem. But the sub-parts I need help with are C, D, and E. But more specifically, really just sub-parts D and E. The only parts I see being answered are sub-parts A, B, and C only in the 8 solutions posted. May I please receive help for the top sub-parts of C, D, and E ONLY, please? It would be much appreciated. Thank you. :) -- Jennifer Sutton

Match the term to its definition by choosing the appropriate number in the answer field.  You will not use all of the terms provided.   Question 8 options:   A partial set of all available data items in a database that are used by a specific application, query, or report.   Fields that link tables with other tables.   The ability of employees at higher levels of responsibility and authority to bypass internal controls.   A field which is unique to each record in a database table.   The total number of transactions in a batch, used as a control total.   Procedures that are put in place to remedy errors or irregularities after they have been discovered.   Controls designed to enhance the control environment and strengthen the effectiveness of application controls.   1. Corrective controls 2. Preventive controls 3. General controls 4. Application controls 5. Record counts 6.…

Need urgent answer please. (1) Is COSO relevant for internal control? This is a full question and not any essay question. Need brief and plagirism free answer.  Answer should not be too short.