관계대수 예제 2 ppt

실습4.pptx

정답지

Suppliers(sid: integer, sname: string, address: string)

Parts(pid: integer, pname: string, color: string)

Catalog(sid: integer, pid: integer, cost: real)

9. Find pairs of sids such that the supplier with the first sid charges more for some

part than the supplier with the second sid.

10. Find the pids of parts supplied by at least two different suppliers.

11. Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham.

차례대로 9 10 11 번 답