Question: Please help using MySQL Workbench. Provide screenshots please! HW#4 MySQL Homework Please create the database in the textbook page 162 (which has 6 tables) and

Please help using MySQL Workbench. Provide screenshots please!

Please help using MySQL Workbench. Provide screenshots please! HW\#4 MySQL Homework Pleasecreate the database in the textbook page 162 (which has 6 tables)

HW\#4 MySQL Homework Please create the database in the textbook page 162 (which has 6 tables) and write SQL script (Please use MySQL and Workbench). Please hand in 1) SQL statement (screen shot), and 2) the query result for each question (screen shot). Please use only standard SQL. Note: you can copy and past the queries and answer tables and then past those in Word document (a) Retrieve the names of employee in department 5 who work more than 10 hours per week on the 'ProductY' project. (b) List the names of employees who have a dependent. (c) Find the names of employee who is the supervisor of 'Joyce English'. (d) For each project, list the project name and the total hours per week (by all employees) spent on that project. (f) Retrieve the names of employees who do not work on any project. (g) For each department, retrieve the department name, and the average salary of employees working in that department. (h) Retrieve the total salary of all male employees. (i) Find the names and addresses of employees who work on at least one project located in Houston. (j) List the last names of department managers who have no dependents. (k) Find the names of employees and all the names of the projects that the employee is working on. (Employees and projects list) (1) Find the names of employees who work on only the employee's own department's projects. \begin{tabular}{|l|l|c|c|c|} \hline DEPARTMENT & DNAME & DNUMBER & MGRSSN & MGRSTARTDATE \\ \hline \multirow{6}{*}{} & Research & 5 & 333445555 & 19880522 \\ \cline { 2 - 5 } & Administration & 4 & 987654321 & 19950101 \\ \cline { 2 - 5 } & Headquarters & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline DNUMBER & DLOCATION \\ \hline 1 & Houston \\ \hline 4 & Stafford \\ \hline 5 & Bellaire \\ \hline 5 & Sugarland \\ \hline 5 & Houston \\ \hline \end{tabular} HW\#4 MySQL Homework Please create the database in the textbook page 162 (which has 6 tables) and write SQL script (Please use MySQL and Workbench). Please hand in 1) SQL statement (screen shot), and 2) the query result for each question (screen shot). Please use only standard SQL. Note: you can copy and past the queries and answer tables and then past those in Word document (a) Retrieve the names of employee in department 5 who work more than 10 hours per week on the 'ProductY' project. (b) List the names of employees who have a dependent. (c) Find the names of employee who is the supervisor of 'Joyce English'. (d) For each project, list the project name and the total hours per week (by all employees) spent on that project. (f) Retrieve the names of employees who do not work on any project. (g) For each department, retrieve the department name, and the average salary of employees working in that department. (h) Retrieve the total salary of all male employees. (i) Find the names and addresses of employees who work on at least one project located in Houston. (j) List the last names of department managers who have no dependents. (k) Find the names of employees and all the names of the projects that the employee is working on. (Employees and projects list) (1) Find the names of employees who work on only the employee's own department's projects. \begin{tabular}{|l|l|c|c|c|} \hline DEPARTMENT & DNAME & DNUMBER & MGRSSN & MGRSTARTDATE \\ \hline \multirow{6}{*}{} & Research & 5 & 333445555 & 19880522 \\ \cline { 2 - 5 } & Administration & 4 & 987654321 & 19950101 \\ \cline { 2 - 5 } & Headquarters & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline DNUMBER & DLOCATION \\ \hline 1 & Houston \\ \hline 4 & Stafford \\ \hline 5 & Bellaire \\ \hline 5 & Sugarland \\ \hline 5 & Houston \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!