Problem
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:
A. Write the needed SQL statement to create the tables
B. Write a couple of statements to insert some data into the tables
C. Write an SQL statement to return all female employees
D. Write an SQL statement to return all employees from a specific department (for example HR)
E. 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.