# answer - Dept_Csc DNAME = CSC ( DEPARTMENT ) Employee_Csc...

This preview shows pages 1–3. Sign up to view the full content.

Margesh  Naik [1]. Retrieve the department name if the department has one location in   Phoenix”.   Dept     σ DLOCATION = “Phoenix”  (DEPT_LOCATIONS)       Dept_Phoenix      DEPARTMENT    ∞  Dept         DNUMBER = DNUMBER    Result       π DNAME   (Dept_Phoenix) [2]. Retrieve the projects (project names), which ‘John Weley’ is working on   more than 20 hours per week. John_Ssn (SSN)      π SSN   σ FNAME = “John” and LNAME = “Weley”  (EMPLOYEE) ) John_Proj   John_Ssn   ∞  Works_On        SSN = ESSN Proj_John_Twentyhr     σ HOURS > 20   ( John_Proj ) Result    π PNAME  ( Project   ∞  Proj_John_Twentyhr )                PNUMBER = PNO 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
[3].  List all female dependents (first name, last name) if they are the   dependents of “CSC” department employees. (“CSC” is department name).
This is the end of the preview. Sign up to access the rest of the 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 ) [4]. 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

## answer - Dept_Csc DNAME = CSC ( DEPARTMENT ) Employee_Csc...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online