Confused on how to even start these questions ?

Create an employee table with the following structure:

A. Social security number (SSN) with character string that cannot be empty since everyone must have a SSN

b. Last name with varying length character that cannot be empty

c. First name with varying length character that cannot be empty

d. Phone number but some people do not have telephone number

2. Populate the employee table with the following data:

SSN LastName FirstName Phone

a. 312456788 Smith John 3174549923

b. 232118857 Robert Lisa 3175452321

c. 443221989 Smith Sue 3178398712

d. 310239856 Pierce Billy NULL

3. What would happen to the following INSERT statement: INSERT INTO EMPLOYEE_TBL Values (Taylor, NULL, 445761212, 3179221331);

4. Display all employees with last name of Smith. If should return two rows.

5. Display only employee(s) with first name of John and last name of Smith

6. For the employee with social security of 312456788, change last name and first name to Larry Conrad.

7. Delete all employees with the last name of Smith.