Problem

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

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. 208)? 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

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search