$(6-7)$ Question $1$:

Write a script to do the following: Use a create table statement to create a new copy of the

L$\_$EMPLOYEES table, with a new name. Then use an insert statement with a select clause to copy

all the data from the L$\_$EMPLOYEES table to your new copy of the table.

$(6-9)$ Question $2$:

Add a primary key to the sec$0609\_$employees table.

$(6-11)$ Question $3$:

Write a script to do the following: Add two new columns to the sec$0611\_$departments table.

One new column, a text column, will be for the name of the manager of the department. The

other new column, a numeric column, is for the annual budget of the department.

$(6-12)$ Question $4$:

Expand the length of the last$\_$name column to the sec$0612\_$employees table. Expand it to a

length of $50$ letters so people with hyphenated last names can be hired by the company.

$(6-13)$ Question $5$:

Delete the phone$\_$number column from a the sec$0613\_$employees table.

$(6-16)$ Question $6$:

Eliminate the duplicate rows from the sec$0616\_$duplicate$\_$rows table.

$(6-17)$ Question $7$:

Assign a number to each row of the sec$0617\_$duplicate$\_$rows table.