Answer the following questions. Use the operator and/or statement asked. Otherwise, you will have zero (0) point for the question. 1. 2. 3. Change the Salary column in the Employee table to reject nulls. Change the length of the CITY column in the Employee table to 50 characters. Change the department name in the Department table to Administration for the department name entitled Admin and Records. Add a department in the Department table. You choose the data for the new department. Delete the new department you added in #4. Add foreign key constraints to Assignment table. 4. 6. 7. 8. Change the column name "Date_of_Birth" to "DOB" in Dependent table. Create a new table structure named "dept_Locations" with "dept_no" and "location" fields. You "isepaninen latlen ov rcnstrainnected to 9. Drop the new table you created in #8. 10.Create a new table named "employee_dependent" table with a SELECT statement. The new table will contain the following data: employee SSN, employee first and last name, employee address, dependent name, the relationship to employee. Note: You have to use SELECT statement. 11.Create an index named LNAMEINDEX based on the field (attribute) LNAME in employee table. 12.Create a view which contains the following information: employee SSN, employee first and last name, and project name assigned to each employee. You have to use 3 tables to create this view. 13.Create a database named "CBT