Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There is 9 questions I need answer fot the whole 9 questions please! and thank you guys. PROJECT Prame Fnumber Plocation num WORKS ON Essn

There is 9 questions I need answer fot the whole 9 questions please! and thank you guys.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

PROJECT Prame Fnumber Plocation num WORKS ON Essn Hours Figure 3.7 DEPENDENT Referential integrity constraints displayed Essn Dependent name l Sex Bdate l Relationship on the COMPANY relational database schem l. Retrieve the average salary, minimum and maximum salary of the male employees. 2. For each department, list its name along with its manager's first name and last name. 3. For each department, list its name, manager's first name and last name, and their dependents' names 4. Retrieve the number of employees of department 5 5. Retrieve the names of employees who work on the project "ProjectX 6. Retrieve the first name and last name of the male employee who has the highest salary 7. Retrieve the first names and last names of the employees who DONT have a dependent 8. For the department that controls the most number of projects, list its name 9. Retrieve the names and SSNs of employees who have at least two dependents

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

Computer Aided Database Design

Authors: Antonio Albano, Valeria De Antonellis, A. Di Leva

1st Edition

0444877355, 978-0444877352

More Books

Students also viewed these Databases questions