76-WXGE6101-L-259200710327 - Department. e) For every...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Consider the following relations: EMPLOYEE(EMPNO , ENAME, BDATE, ADDRESS, GENDER, DNO, SALARY) DEPARTMENT(DNUMBER, DNAME, MANAGERNUM) DEPENDENT(DEPNAME,ENO , DEPSEX,DEPDATE,RELATIONSHIP) PROJECTS(PNO, PNAME, LOCATION, DNO) WORKS_ON (ENO,PNO , HOURS) Use SQL to answer the following queries: a) Find the birthdates and addresses of all employees. b) Find the names of all managers. c) Find the salary of the employee whose name is 'Mohd Aziz'. d) Find the names and addresses of all employees who work for the “Research”
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Department. e) For every project located in Kuala Lumpur, list the project number, the controlling department number, the department managers name, address and birth date. f) Find the names of all projects controlled by department D05. g) List the names of all employees and their dependents. h) List all salaries. i) List distinct salaries...
View Full Document

This note was uploaded on 02/06/2012 for the course FACULTY OF WXGE6320 taught by Professor Noraini during the Winter '09 term at University of Malaya.

Ask a homework question - tutors are online