This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Dept_Csc DNAME = CSC ( DEPARTMENT ) Employee_Csc Employee Dept_Csc DNO = DNUMBER Dependent_Employee_Csc Employee_Csc Dependent SSN = ESSN Female_Dependent SEX = F (Dependent_Employee_Csc ) Result DEPENDENT_NAME , LNAME (Female_Dependent ) . Find the names of employees that are directly supervised by 'Mike Miller'. Mike_Ssn ( SSN) SSN ( FNAME = Mike and LNAME = Miller (EMPLOYEE)) 2 Employee_Under_Mike Mike_SSN Employee SSN = SUPERSSN Result FNAME, MINIT, LNAME (Employee_Under_Mike) Consideration: : Project Operation : Join Operation : Select Operation 3...
View Full Document
- Spring '09