Computers and Technology, 22.02.2021 18:40 alwaysneedhelp84

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.

a. Find the pnames of parts for which there is some supplier.
b. Find the snames of suppliers who supply every part.
c. Find the snames of suppliers who supply every red part.
d. 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.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 05:00, 420420blazee

Are special characters that allow you to search for multiple words at the same time.

Answers: 2

continue

Computers and Technology, 22.06.2019 22:00, suewignall

During physical science class ben and jerry connected three identical lightbulbs in parallel to a battery where happens when ben removes one of the lightbulbs from it’s socket

Answers: 2

continue

Computers and Technology, 23.06.2019 18:00, bubbles173883

While inserting images, the picture command is usually used to insert photos from a digital camera, and the clip art command is usually used to a. edit the sizes and other characteristics of photos that have been inserted. b. take a screenshot of an image and copy it to the clipboard for pasting. c. search for drawings or other images from a library of prepared pictures. d. make illustrations using lines and shapes that are easy to manipulate.

Answers: 1

continue

Computers and Technology, 24.06.2019 02:20, Jonny13Diaz

The first time a user launches the powerpoint program, which view is shown allowing the user to access recent presentations or create new presentations based on templates?

Answers: 1

continue

You know the right answer?

Consider the following schema: Suppliers ( sid: integer, sname: string, address: string )
Par...