1. Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE. 2. Write INSERT statements to add the data shown in Figure 1-29 to the DEPARTMENT table. Run these...

1. Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE.

2. Write INSERT statements to add the data shown in Figure 1-29 to the DEPARTMENT table. Run these statements to populate the DEPARTMENT table. (Hint: Write and test an SQL script, and then run the script. Save the script as WPC-Insert DEPARTMENT-Data. SQL for future use.)

3. Write INSERT statements to add the data shown in Figure 1-31 to the EMPLOYEE table. Run these statements to populate the EMPLOYEE table. (Hint: Write and test an SQL script, and then run the script. Save the script as WPC-Insert-EMPLOYEE Data. SQL for future use.)