P$1.$ Write the SQL code that will create only the table structure for a table named EMP$\_1.$ This table P$7.$ Using the EMP$\_2$ table, write the SQL code that will add the attributes EMP$\_$PCT and PROJ$\_$NUM

to EMP$\_2.$ The EMP$\_$PCT is the bonus percentage to be paid to each employec. The new attribute

characteristics are:

P$8.$ Using the EMP$\_2$ table, write the SQL code to change the EMP$\_$PCT value to $3\mathrm{.}85$ for the person

whose employee number $($EMP$\_$NUM$)$ is $103.$

P$9.$ Using the EMP$\_2$ table, write a single SQL command to change the EMP$\_$PCT value to $5\mathrm{.}00$ for the

people with employee numbers $101,105,$ and $107.$

PIO. Using the EMP$\_2$ table, write a single SQL command to change the EMP$\_$PCT value to $10\mathrm{.}00$ for all

employees who do not currently have a value for EMP$\_$PCT$.$

P$11.$ Using the EMP$\_2$ table, write the SQL command to add $.15$ to the EMP$\_$PCT of the employee whose

name is Maria D$.$ Alonzo. $($Use the employce name in your command to determine the correct

employee.$)$

PI$2.$ Using a single command sequence with the EMP$\_2$ table, write the SQL code that will change the

project number $($PROJ$\_$NUM$)$ to $18$ for all employees whose job classification $($JOB$\_$CODE$)$ is $500.$

P$13.$ Using a single command sequence with the EMP$\_2$ table, write the SQL code that will change the

project number $($PROJ$\_$NUM$)$ to $25$ for all employees whose job classification $($JOB$\_$CODE$)$ is $502$ or

higher.

P$14.$ Write the SQL code that will change the PROJ$\_$NUM to $14$ for employees who were hired before

January $1,1998,$ and whose job code is at least $501.$ When you finish Problems $6,7,8,9,10,11,$

$12,13,$ and $14,$ the EMP$\_2$ table will contain the data shown in Figure $3.$

Figure $3$: The contents of the the EMP$\_2$ Table

will be a subset of the ERPLOYEE table. The basic ERP$\_1$ table structure is summarized in Table $1.$

Use EMP$\_$NUM as the primary key. Note that the JOB$\_$CODE is the FK to JOB so be certain to enforce

referential integrity. Your code should also prevent null entries in EMP$\_$LNAME and EMP$\_$FNAME.

Table $1$: The EMP$\_1$ table structure

P$2.$ Having created the table structure in problem Pl$.,$ write the SQL code to enter the first two rows

from the table shown in Figure $2.$ Each row should be inserted individually, without using a

subquery. Insert the rows in the order that they are listed in the figure.

Figure $2$: The contents of the the EMP$\_1$ Table

P$3.$ Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from

the EMPLOYEE table into the EMP$\_1$ table. Remember, your subquery should only retrieve the

columns needed for the EMP$\_1$ table and only the employees shown in Figure $2.$

P$4.$ Write the SQL code to change the job code to $501$ for the person whose employee number

$($EMP$\_$NUM$)$ is $107.$

P$5.$ Write the SQL code to delete the row for William Smithfield, who was hired on June $22,2008,$

and whose job code is $500.($Hint: Use logical operators to include all of the information given in

this problem.

P$6.$ Write the SQL code to create a copy of EMP$\_1,$ including all of its data, and naming the copy

EMP$\_2.$