BuyFindarrow_forward

Accounting Information Systems

11th Edition
Ulric J. Gelinas + 3 others
ISBN: 9781337552127

Solutions

Chapter
Section
BuyFindarrow_forward

Accounting Information Systems

11th Edition
Ulric J. Gelinas + 3 others
ISBN: 9781337552127
Textbook Problem

As we noted when presenting the recommended control plans in the matrix in Figure 12.13 (pp. 482–483) that are discussed in Exhibit 12.1 (pp. 486–487), we intentionally limited the number of plans to avoid redundancy. For example, we did not include several plans from Chapter 9 such as preformatted screens, online prompting, programmed edit checks (e.g., a reasonableness test on the purchase quantity), procedures for rejected inputs, confirm input acceptance, digital signature, and populate input screens with master data. We could also include enter receipts data hi receiving. Prepare a control matrix for just these controls. Include explanations of how each recommended existing control plan helps to accomplish—or would accomplish in the case of missing plans—each related control goal.

Annotate the flowchart in Figure 12.12 (pp. 478–479) to indicate the points where the control plans are being applied (codes P-l, ..., P-n) or the points where they could be applied hut are not (codes M-l, ..., M-n).

Summary Introduction

To prepare: Control matrix and explanations of how each recommended existing control plan helps to accomplish in the case of missing plan for each related control goals.

Explanation

Steps:

  • Firstly, identify the required SQL command to add an employee hire date to a pre-existing table.
  • Then it is necessary to identify the required SQL commands to add the given values.
  • The SQL command that adds the employee date to the employee table is:
    • ALTER TABLE EMPLOYEE

      ADD COLUMN Employment_Date Integer NOT NULL

  • The above command alters the employee table and includes “Employment_Date” as the new field.
  • Employee 1:
    • UPDATE EMPLOYEE

      SET Employment_Date=20000522

      WHERE Employee_No= 'B432'

    • The above command helps in adding the employment date to the particular employee number within the table.
  • Employee 2:
    • UPDATE EMPLOYEE

      SET Employment_Date=20010103

      WHERE Employee_No= 'A491'

    • The above command helps in adding the employment date to the particular employee number within the table...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Business Solutions

Find more solutions based on key concepts

Show solutions add

In what ways can the cost of a process be improved?

Financial And Managerial Accounting

What are nonvalue-added activities? Nonvalue-added costs? Give an example of each.

Managerial Accounting: The Cornerstone of Business Decision-Making

REGRESSION AND RECEIVABLES Edwards Industries has 320 million in sales. The company expects that its sales will...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)