please answer SQL questions 7-13. Provide SQl statement only. thanks

below is the information for the questions

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