"Use Oracle (or close equivalent) to implement the following MIS COMPANY database.
• Table 1: 'Employees' includes the first name, middle initial, and last name of every worker in the company, as well as their SIN, date of birth, address, sex, salary, and the number of the department with which they are associated.
• Table 2: 'Departments' indicates the name (Consumer Products, Industrial Products, and Research) and number of each department in the company, and the SIN and start date of the manager of each department.
• Table 3: 'Projects' includes the project name and number, the number of the department in charge of the project, and the location of the office working on the project.
• Table 4: 'Locations' lists the locations of all the offices of each department.
Table 1: Employees
FNAME MINIT LNAME SIN BDATE ADDRESS SEX SALARY DNO
Harris T Chomsky 123 1955-12-10 France M 50,000 12
Kristian C Bohr 456 1965-10-05 New york M 28,000 11
Charlotte F Bouchard 789 1975-08-06 Montreal F 40,000 11
Said J Ahmad 111 1960-09-07 Toronto M 30,000 12
Andrew U Brahe 222 1970-04-02 Winnipeg M 20,000 10
Nadia O Mamary 333 1950-01-08 Saskatoon F 35,000 10
Peter P Nielsen 987 1973-02-27 Moncton M 32,000 11
Neil A Dion 654 1953-02-27 Moncton M 32,000 11
Karen C Ming 321 1963-11-16 Victoria F 26,000 12
Table 2: Departments
DNAME DNUMBER MGRSIN MGRSTARTDATE
ConsProd 10 333 1994-10-01
InduProd 11 654 1995-05-01
Research 12 111 1990-06-15
Table 3: Projects
PNAME PNUMBER PLOCATION DNUM
Mobile University 1 New york 10
E-commerce 2 New york 12
Intelligent Agent 3 London 11
Virtual city 4 France 10
Mobile Office 5 London 11
Table 4: Locations
DNBR DLOCATION
10 France
10 New york
11 London
12 New york
12 Montreal
f.The company administration has decided to change the number of the research department from "12" to "14". Write an SQL query that performs this update. Your query should make use of your trigger (from d) to ensure database integrity.
g.Write an SQL statement to retrieve the number of people working in each of the departments responsible for mobile technology projects.
h.Retrieve the department name, and the number of female employees working for each department whose average salary is more than 27K. "