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

Human Resources department needs the work time, vacation time, and sick time for Greg Kinman (see the EMPLOYEE table in Figure 6.13). What SQL command(s) would you use to extract this information from the tables in Figure 6.13?

Note: These problems should be completed with a database software package such as Access. For Problems 6-3 and 6-4, you may use data that you (or your instructor) have downloaded from an accounting database. Problem 6-5 demonstrates the interaction between an application software system and the database.

Summary Introduction

To determine: The appropriate SQL command to be used for extracting information like work time, vacation time and sick time.

Explanation

SQL:

SQL is a standard language that is used to sort, manipulate and retrieve the data from database. It is also used to define, query, and generate reports. Composition of query language is very important in order to derive information from the database.

The SQL commands that can be used to retrieve the work time, vacation time, and sick time of the employee with name, Janet Robins in figure 6.13:

  • Work time:
    • SELECT EMPLOYEE.Emploee_No, Name, Client_No, Date, Hours

      FROM EMPLOYEE, WORK_COMPLETED

      WHERE EMPLOYEE.Employee_No= 'A491'

  • The above written commands retrieve the hours of work time of the employee with employee number “A491”. This data is retrieved from the “WORK_COMPLETED” 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

What are the steps in entering international markets?

Foundations of Business (MindTap Course List)

Conciseness es valued in business. However, can messages be too short?

Essentials of Business Communication (MindTap Course List)

REQUIRED LUMP SUM PAYMENT Starting next year, you will need 10,000 annually for 4 years to complete your educat...

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

Who usually administers a bond sinking fund?

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)