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

What SQL command(s) would you use to add the date on which an employee was hired to the EMPLOYEE table represented in Figure 6.13 (pg. 213)? Name this new attribute Employment_Date. Assume that the employees were hired on the following dates, using a year-month-day format as YYYYMMDD:

  • Carl Elks 20000522
  • Janet Robins 20010103
  • Greg Kinman 19970825
  • Christy Bazie 20040801
  • Elaine Kopp 20060912
  • John Mast 19950709

Summary Introduction

To determine: The appropriate SQL command to be used to add date on which an employee was hired.

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

COST OF COMMON EQUITY WITH FLOTATION Ballack Co.s common stock currently sells for 46 75 per share. The growth ...

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

How is a DBMS different from a database?

Pkg Acc Infor Systems MS VISIO CD

How does the journal differ from the ledger?

College Accounting (Book Only): A Career Approach