The ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project.

proj$\_$Darance

a$)$ Write the SQL code that will create the table structure for a table named EMP$\_1.$ This table is a subset of the EMPLOYEE table. The basic EMP$\_1$ table structure is summarized in the table below. $($Note that the JOB$\_$CODE is the FK to JOB.$)$

$(4)$

$\backslash$table$[[$ATTRIBUTE $($FIELD$)$ NAME,DATA DECLARATION$],[$EMP$\_$NUM,CHAR$(3)],[$EMP$\_$LNAME,VARCHAR$(15)],[$EMP$\_$FNAME,VARCHAR$(15)],[$EMP$\_$INITIAL,CHAR$(1)],[$EMP$\_$HIREDATE,DATE$],[$JOB$\_$CODE,CHAR$(3)]]$

b$)$ Having created the table structure in a$),$ write the SQL code to enter the first two rows for the table shown in the following table:

$(2)$