Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please be quick EMPLOYEE DEPARTMENT DEPT_LOCATIONS begin{tabular}{|l|c|c|c|} hline multicolumn{1}{|c|}{ Drame } & Dnumber & Mozisa & Mor_start_date hline Reseach & 5 & 333445555 &

please be quick
image text in transcribed
image text in transcribed
EMPLOYEE DEPARTMENT DEPT_LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Drame } & Dnumber & Mozisa & Mor_start_date \\ \hline Reseach & 5 & 333445555 & 19060522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquatiors & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Deumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Staftord \\ \hline 5 & Belaine \\ \hline 5 & Sugarland \\ \hline 5 & Houstion \\ \hline \end{tabular} WORKS ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pro & Houn \\ \hline 123456780 & 1 & 32.5 \\ \hline 123456789 & 2 & 7. \\ \hline 666881411 & 2 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 403453463 & 2 & 200 \\ \hline 333446656 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 100 \\ \hline 999087777 & 30 & 30.0 \\ \hline 999697777 & 10 & 10.0 \\ \hline 967987967 & 10 & 25.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 967654321 & 20 & 15.0 \\ \hline 888665556 & 20 & NULL \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 25 using the SQL nota Question 2 (20 points) List the first name and last name of all supervisors who supervise the emplovees working for the "Research" department. Order the list by supervisor first name in ascending order. Question 3 (20 points) Write an UPDATE query to decrease the salary of employees working on the "Productr" project by 5%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 4.5 Databases

Authors: Sandeep Chanda, Damien Foggon

3rd Edition

1430243805, 978-1430243809

Students also viewed these Databases questions