Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1:A) For each department, list all the employees who are working in the department with the employee?s first and last name and first and last

Q1:A) For each department, list all the employees who are working in the department with the employee?s first and last name and first and last name of his or her immediate supervisor. Include all the departments and all the employees (including who do not have any supervisor). List the result in the order of each department number and first name of each employee.

B) List all the employees (including who do not have any supervisor) but do not list the departments that no employee is working for in the output.

C) Get SSN and the last name of married female employees who work on three or more projects.

D) List the name of employees who is working for ?Research? department and are married but have no children.

E) Get the last name of married employees who only have daughters.

F) Give the last name and ssn of those employees who work in any project(s) where there are more female than male employees.

image

image

image

Referential integrity constraints displayed on the COMPANY relational database schema. EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship Dno

Step by Step Solution

3.50 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

Q1A SELECT dDnumber AS DepartmentNumber eLname AS EmployeeLastName eFname AS EmployeeFirstName sLnam... 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_2

Step: 3

blur-text-image_3

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

Accounting Information Systems basic concepts and current issues

Authors: Robert Hurt

3rd edition

130855849X, 978-1308558493, 78025338, 978-0078025334

More Books

Students also viewed these Programming questions

Question

Calculate the missing values

Answered: 1 week ago