IS620 Assignment

IS620 Assignment - in your Company table (e.g., New York)....

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

View Full Document Right Arrow Icon
IS 620 Assignment 2 Due 2/10. Suppose you have created tables in assignment 1 listed below. Please write SQL statements for the following problems. Tables: Employee(employee_name, street, city) Works(employee_name, company_name, salary) Company(company_name, city) Manages(employee_name, manager_name) Problems 1. Find the names of all employees whose company is at Baltimore. If your Company table does not have companies located at Baltimore, use any city name
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: in your Company table (e.g., New York). [30 points] 2. Find the names of employees who work at the same company as Jeff. [30 points] Hint: use self join. 3. Find all employees in the database who live in the same cities and on the same streets as do their managers. [40 points] Hint: use self join and note that a manager is an employee of the company as well. Please submit print-out of SQL statements....
View Full Document

Ask a homework question - tutors are online