Consider the following schema:

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

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

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

The Catalog relation lists the prices charged for parts by Suppliers.

Write the following queries in SQL.

1. Find the pnames of parts for which there is some supplier.

2. Find the snames of suppliers who supply every part.

3. Find the snames of suppliers who supply every red part.

4. Find the sids of suppliers who supply only red parts.

5. Find the sids of suppliers who supply a red part and a green part.

solution:

bookmark is a word, symbol, image, or other object that links you to another element in another location.

bookmark is a saved shortcut that directs your browser to a specific webpage. it stores the title, url, and favicon of the corresponding page. saving bookmarks allows you to easily access your favorite locations on the web.

it works in all modern web browsers include bookmark features. bookmarks are called favorites or internet shortcuts in internet explorer, and by virtue of that browser's large market share, these terms have been synonymous with bookmark since the first browser war.