assignment5 - employees working for First Bank Corp (you...

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

View Full Document Right Arrow Icon
IS 620 Assignment 5 Due 3/3 Suppose you have created tables in assignment 1: Employee(employee_name, street, city) Works(employee_name, company_name, salary) Company(company_name, city) Manages(employee_name, manager_name) Problem 1. Use implicit cursor to print out the name of manager of Alice. Please handle exceptions. [30 points] Problem 2. Use explicit cursor to print out the employee_name, street, and city of all
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: employees working for First Bank Corp (you can also use any company name you have in your company table). [30 points] Problem 3. [40 points] Use explicit cursor to print out the names of two cities with the most number of companies. In case of tie, just print out the first two. Please submit print-out of code. You can also email the instructor your answer before 3/3 to get some early feedback....
View Full Document

This note was uploaded on 02/28/2012 for the course IS 620 taught by Professor Chen,z during the Spring '08 term at UMBC.

Ask a homework question - tutors are online