dence of all employees whoworkfor First Bank Corporation.b. Find the names, street addresses, and cities of residenceof all em-ployees who work for First Bank Corporation and earn more than$10,000.c. Find all employees in the database who do not work for FirstBankCorporation.d. Find all employees in the database who earn more than each em-ployee of Small Bank Corporation.e. Assume that panies may be located in several cities. Find panies located in every city in which Small Bank Corporation islocated.f. Find pany that has the most employees.g. Find panies whose employees earn a higher salary, onaverage, than the average salary at First Bank Corporation.Answer:employee(employeename,street,city)works(panyname,panyname,city)manages(employeename,managername)Figure 3.20. Employee database.
全文预览
