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. 205)? 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 19990522

• Janet Robins 20010105

• Greg Kinman 19971125

• Christy Bazie 20020801

• Elaine Kopp 20060916

• John Mast 19951209