What SQL command(s) would you use to add the date on which an employee was hired to

Question:

What SQL command(s) would you use to add the date on which an employee was hired to the EMPLOYEE table represented in Figure? 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
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Accounting Information Systems

ISBN: 978-1133935940

10th edition

Authors: Ulric J. Gelinas, Richard B. Dull

Question Posted: