Consider the following relational schema. Relational schema: Employee( empid: integer deptid integer, age: integer, gender: char(1)) Department (deptid: integer, deptname: char(20), floor. integer, phone: char (10)) Marketing (deptid. integer, budget real, expenses: real) You are requested to do the following: 1- write the needed SQL statement to create the tables 2- write a couple of statements to insert some data into the tables 3- write an SQL statement to return all female employees 4- write an SQL statement to return all employees from a specific department (for example HR) 

5- write a join SQL statement to list all the departments and their marketing information. If any department has nothing in the marketing table, then "null" or "' should appear.