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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
[3].  List all female dependents (first name, last name) if they are the   dependents of “CSC” department employees. (“CSC” is department name).
Background image of page 2
Background image of page 3
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

Page1 / 3

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 Right Arrow Icon
Ask a homework question - tutors are online