Connect to the database you created and named in Module One $($for example, Jetson$).$ Type after the prompt mysql$>$

use $($table you named$)$;

Example: mysql$>$ use Jetson;

Create the Employee table using the SQL statement shown here. Press Return after each line.

CREATE TABLE Employee $($

Employee$\_$ID SMALLINT,

First$\_$Name VARCHAR$(40),$

Last$\_$Name VARCHAR$(60),$

Department$\_$ID SMALLINT,

Classification VARCHAR$(10),$

STATUS VARCHAR$(10),$

Salary DECIMAL$(7,2))$;

Create the Branches table. Fill in the missing characters or punctuation in the incomplete statement shown below to complete this action.

CREATE Branches $($

Department$\_$ID SMALLINT,

Department$\_$Name $)$

After creating the tables, use the correct commands to describe them $.$ You$$ll only be given commands to describe one of the tables and must complete the same action for the second one on your own. Validate your work with a screenshot.

describe Employee;

Write the correct command to describe the Branches table

Insert the following records into the Employee table $($with support$).$ Each line going from left to right is a record. Each line going from top to bottom is a column. Validate your work with a screenshot.

INSERT INTO Employee VALUES $(100,$ 'John', 'Smith', $1,$ 'Exempt', 'Full$-$Time', $90000),$

$(101,$'Mary','Jones',$2,$'Non$-$Exempt','Part$-$Time',$35000),$

$(102,$'Mary','Williams',$3,$'Exempt','Full$-$Time',$80000)$;

Type the command select$*$ from Employee; and take a screenshot of it to validate this step.

Insert the following records into the Employee table for Gwen Johnson and Michael Jones by writing the correct SQL commands on your own $($without support$).$

Gwen Johnson: Employee ID $=103,$ DEPARTMENT$\_$ID $=4,$ Classification $=$ NULL, Status $=$ Full$-$Time, SALARY $=40000$

Michael Jones: Employee ID $=104,$ DEPARTMENT$\_$ID $=4,$ Classification $=$ Non$-$Exempt, Status $=$ Full$-$Time, SALARY $=90000$

Insert your name into the table to verify and prove your work.

$($Your First and Last Name, or a nickname$)$: Employee ID $=105,$ DEPARTMENT$\_$ID $=1,$ Classification $=$ Non$-$Exempt, Statues $=$ Full$-$time, SALARY $=($Choose a value between $50000$ and $99000)$

Type the command select$*$ from Employee; and take a screenshot of it to validate this step.

Insert records for a musician, athlete, or other famous character of your choice. Make sure to enter information for all of the fields listed in this table. The Department$\_$ID must be a number between $1$ and $4.$

Write the correct command to prove that you$$ve successfully completed this step, and validate it with a screenshot.

Select the fields of last name, first name, and department id from the table. Validate your work with a screenshot.

Select First$\_$Name, Last$\_$Name, Employee$\_$ID$,$ Department$\_$ID from Employee;