Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please hurry up 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 hurry up
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 How many supervisees does each of the supervisors working for "Research" department have? Question 5 (20 points) Which employee has the maximum number of dependents. List SSN, first name and last name of the emloyee. Hint: Use inner query with IN or NOT IN operator whichever is appropriate

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

Database Design Application Development And Administration

Authors: Mannino Michael

5th Edition

0983332401, 978-0983332404

More Books

Students also viewed these Databases questions

Question

Identify ways to increase your selfesteem.

Answered: 1 week ago