Employees includes the first name


"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. "  

Request for Solution File

Ask an Expert for Answer!!
Programming Languages: Employees includes the first name
Reference No:- TGS0110651

Expected delivery within 24 Hours