Hello,

Expert reply only. Use the relational schema to provide SQL queries. (For Oracle)

RELATIONAL SCHEMA:

EMPLOYEE (FNAME, MINIT, LNAME, SSN, BDATE, ADDRESS, SEX, SALARY, #SUPERSSN, #DNO)

DEPARTMENT (DNAME, DNUMBER, #MGRSSN, MGRSTARTDATE)

DEPT_LOCATIONS (#DNUMBER, DLOCATION)

PROJECT (PNAME, PNUMBER, PLOCATION, #DNUM)

WORKS_ON (#ESSN, #PNO, HOURS)s

DEPENDENT (#ESSN, DEPENDENT_NAME, SEX, BDATE, RELATIONSHIP)

Provide sql query/statements: (To be run in Oracle)

A. For each employee, retrieve the employee's first and last name and the first and last name of the his or her immediate supervisor.

B. Retrieve the name of each employee who has a dependent with the same first name and same sex as the employee.

C. For each project on which more than two employees work, retrieve the project number, the project name, and the number of employees who work on that project.

D. Find all employees who were born during the 1950s.