아까랑 비슷한 문제들인데 풀어주면 고맙겠읍니다.
공부해서 스스로 하고 싶지만 과제가 내일 아침까지라 책보고하기엔
너무 늦은것 같아서요.

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

employee(employee-name, street, city)

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

company(company-name, city)

manages(employee-name, manager-name)


 

c.

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

d.

Modify the database so that Jones (employee) now lives in Newtown.

e.

Delete all tuples in the companies located in Boston.

f.

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.

g.

Add tuples for Dshong employee. He lives on the Summer street in LosAngeles and works for Small Bank. His salary is $2,500.

h.

Modify the database so that all employees now works for Small Bank.

i.

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


c~i번까지 7문제 제발 부탁 TT