이거 3문제 풀어주세요.TT DBMS는 오라클.


데이타베이스는 다음과 같음

employee(employee-name, street, city)

works(employee-name, company-name, salary)

company(company-name, city)

manages(employee-name, manager-name)


 

1, 

Find all employees in the database who live in the same cities and on the same streets as do their managers.

 

2,

Give all employees of First Bank Corporation a 10 percent raise unless the salary becomes greater than $100,000; in such cases, give only a 3 percent raise.

 

3,

Add tuples for some employees didn\'t have their manager. Their manager is KING and KING has no manager.