1. List the name of division that has more than 1 project with… Image transcription textWith the tables you created: Division (DID, dname, managerID) Employee (empID, name, salary, DID) Project(PID, pname, budget, DID) Workon (PID, EmpID, hours)… Show more1.List the name of division that has more than 1 project with budget over $1000 and have 2 employees working on it. 2. List the name of employees who is not from ‘accounting’ division and work on project “web development”.3. List the name of employees who work on more projects than any employee from ‘marketing ‘ division. (use “>= ALL (select count (pid) …”)4. List the name of each division that does not sponsor project ‘DB development’ but has some employee(s) working on it. 5. Among all projects ‘Chen’ works on, list the name of project that has lowest budget.6. Among all employees who work on “DB development”, list the name of employee who makes least salary.7. List the name of project that has more employees from Engineering division working on it than the employees from marketing division. (hint: use … WHERE (….) > (….) )8. List the names of employee who work on ALL projects sponsored by chen’s division.This is the script file that you need to create the database tables, as shown in the picture. You will need these scripts to create the database table in order to answer the questions. drop table workon; drop table employee; drop table project; drop table division; create table division (did integer, dname varchar (25), managerID integer, constraint division_did_pk primary key (did) ); create table employee (empID integer, name varchar(30), salary float, did integer, constraint employee_empid_pk primary key (empid), constraint employee_did_fk foreign key (did) references division(did) ); create table project (pid integer, pname varchar(25), budget float, did integer, constraint project_pid_pk primary key (pid), constraint project_did_fk foreign key (did) references division(did) ); create table workon (pid integer, empID integer, hours integer, constraint workon_pk primary key (pid, empID),constraint workon_pid_fk foreign key (pid) references project(pid), constraint workon_empid_fk foreign key (empID) references employee(empID) ); /* loading the data into the database */ insert into division values (1,’engineering’, 2); insert into division values (2,’marketing’, 1); insert into division values (3,’human resource’, 3); insert into division values (4,’Research and development’, 5); insert into division values (5,’accounting’, 4); insert into project values (1, ‘DB development’, 8000, 2); insert into project values (2, ‘network development’, 6000, 2); insert into project values (3, ‘Web development’, 5000, 3); insert into project values (4, ‘Wireless development’, 5000, 1); insert into project values (5, ‘security system’, 6000, 4); insert into project values (6, ‘system development’, 7000, 1); insert into employee values (1,’kevin’, 32000,2); insert into employee values (2,’joan’, 42000,1); insert into employee values (3,’brian’, 37000,3); insert into employee values (4,’larry’, 82000,5); insert into employee values (5,’harry’, 92000,4); insert into employee values (6,’peter’, 45000,2); insert into employee values (7,’peter’, 68000,3); insert into employee values (8,’smith’, 39000,4); insert into employee values (9,’chen’, 71000,1); insert into employee values (10,’kim’, 46000,5); insert into employee values (11,’smith’, 46000,1); insert into employee values (12,’joan’, 48000,1); insert into employee values (13,’kim’, 49000,2); insert into employee values (14,’austin’, 46000,1); insert into employee values (15,’sam’, 52000,5);insert into employee values (16,’Justin’, 62000,2); insert into employee values (17,’Nacy’, 52000,1);insert into employee values (18,’Marilyn’, 52000,5);insert into employee values (19,’Kristie’, 52000,1);insert into employee values (20,’John’, 52000,3);insert into employeevalues (21,’Alex’, 69000,1); insert into employee values (22,’Phil’, 72000,2);insert into employee values (23,’Steve’, 74000,4);insert into employee values (24,’Jenna’, 69000,1);insert into employee values (25,’Alan’, 62000,2);insert into employeevalues (26,’Julia’, 69000,4); insert into employee values (27,’Sandra’, 72000,4);insert into employee values (28,’Joe’, 74000,4);insert into employee values (29,’karl’, 69000,5);insert into employee values (30,’grace’, 62000,4);insert into workon values (3,1,30); insert into workon values (2,3,40); insert into workon values (5,4,30); insert into workon values (6,6,60); insert into workon values (4,3,70); insert into workon values (2,4,45); insert into workon values (5,3,90); insert into workon values (3,3,100); insert into workon values (6,8,30); insert into workon values (4,4,30); insert into workon values (5,8,30); insert into workon values (6,7,30); insert into workon values (6,9,40); insert into workon values (5,9,50); insert into workon values (4,6,45); insert into workon values (2,7,30); insert into workon values (1,8,30); insert into workon values (2,9,30); insert into workon values (1,9,30); insert into workon values (2,8,30); insert into workon values (1,7,30); insert into workon values (1,5,30); insert into workon values (1,6,30); insert into workon values (2,6,30);insert into workon values (2,12,30);insert into workon values (3,13,30);insert into workon values (4,14,20);insert into workon values (4,15,40);insert into workon values (2,19,30); insert into workon values (1,19,30); insert into workon values (5,18,30); insert into workon values (3,17,30); insert into workon values (4,25,30); insert into workon values (3,16,30); insert into workon values (2,16,30);insert into workon values (2,22,30);insert into workon values (3,23,30);insert into workon values (4,24,20);insert into workon values (6,25,40);insert into workon values (3,21,40);insert into workon values (4,26,20);insert into workon values (4,27,40);insert into workon values (2,27,30); insert into workon values (1,26,30); insert into workon values (5,26,30); insert into workon values (3,26,30); insert into workon values (4,28,30); insert into workon values (3,28,30); insert into workon values (2,29,30);insert into workon values (2,30,30);insert into workon values (3,30,30);insert into workon values (4,21,20);insert into workon values (6,22,40);insert into workon values (1,30,40);insert into workon values (3,9,10);insert into workon values (4,9,20);Computer ScienceEngineering & TechnologyMYSQL INFO 574
solved : 1. List the name of division that has more than 1 project wi
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assigned to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades
LET THE PROFESSIONALS WRITE YOUR PAPER!