Please answer question 7-13 according to the images below. SQL statement needed only

Thanks.

7. Change the column name "Date of Birth" to "DOB" in Dependent table. 8. Create a new table structure named "dept Locations" with "dept_no" and "location" fields. You also have to put primary and foreign key constraints so that this table is connected to "department" table. 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