Question
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
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) DEPENDENT (#ESSN, DEPENDENT_NAME, SEX, BDATE, RELATIONSHIP)
in SQL, find the SSN"s of the employee who works on every project that john smith works on.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Practical Oracle8I Building Efficient Databases
Authors: Jonathan Lewis
1st Edition
0201715848, 978-0201715842
