Create and submit a sql script to answer all the questions. Make sure to add comments in the document to add title for each question. Use Chapter $8$ database script to create your database that you can use to test your script: Ch$08\_$ConstructCo$\_$MySQL$.$sql and Ch$08\_$SaleCo$\_$MySQL$.$sql $1.$ Write the SQL code that will create only the table structure for a table named EMP$\_1.$ This table will be a subset of the EMPLOYEE table. The basic EMP$\_1$ table structure is summarized in the following table. 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. $2.$ Having created the table structure in Problem $1,$ write the SQL code to enter the first two rows for the table shown in Figure P$8\mathrm{.}2.$ Each row should be inserted individually, without using a subquery. Insert the rows in the order that they are listed in the figure. $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 the figure. $4.$ Write the SQL code that will save the changes made to the EMP$\_1$ table $($if supported by your DBMS$).5.$ Write the SQL code to change the job code to $501$ for the person whose employee number $($EMP$\_$NUM$)$ is $107.6.$ 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. Remember, if you are using MySQL$,$ you will have to first disable "safe Mode,$)7.$ Write the SQL code to create a copy of EMP$\_1,$ including all of its data, and naming the copy EMP$\_2.8.$ 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 employee. The new attribute characteristics are: EMP$\_$ DECIMAL$(4,2)$ PROJ$\_$NUM CHAR$(3)9.$ 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.10.$ 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.$ Use the following table to answer the remaining questions. $11.$ Create a trigger named trg$\_$line$\_$total to write the LINE$\_$TOTAL value in the LINE table every time you add a new LINE row. $($The LINE$\_$TOTAL value is the product of the LINE$\_$UNITS and LINE$\_$PRICE values.$)12.$ Create a trigger named trg $\_$line$\_$prod that automatically updates the quantity on hand for each product sold after a new LINE row is added. $13.$ Create a stored procedure named pre$\_$inv $\_$amounts to update the INV$\_$SUBTOTAL, INV$\_$TAX, and INV$\_$TOTAL. The procedure takes the invoice number as a parameter. The INV$\_$SUBTOTAL is the sum of the LINE$\_$TOTAL amounts for the invoice, the INV$\_$TAX is the product of the INV$\_$SUBTOTAL and the tax rate $(8$ percent$),$ and the INV$\_$TOTAL is the sum of the INV$\_$SUBTOTAL and the INV$\_$TAX. $14.$ Create a procedure named pre$\_$cus$\_$balance$\_$update that will take the invoice number as a parameter and update the customer balance. $($Hint: You can use DECLARE to define a TOTINV numeric variable that holds the computed invoice total.$)$