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, 21.06.2019 17:20, gracie0818

Q-3 a technician is setting up a computer lab. computers on the same subnet need to communicate with eachother peer to peer communication, a. hardware firewallb. proxy serverc. software firewalld. gre tunneling

Answers: 3

continue

Computers and Technology, 22.06.2019 14:30, qxchung7310

The “rule of 72” is used to approximate the time required for prices to double due to inflation. if the inflation rate is r%, then the rule of 72 estimates that prices will double in 72/r years. for instance, at an inflation rate of 6%, prices double in about 72/6 or 12 years. write a program to test the accuracy of this rule. for each interest rate from 1% to 20%, the program should display the rounded value of 72/r and the actual number of years required for prices to double at an r% inflation rate. (assume prices increase at the end of each year.)

Answers: 1

continue

Computers and Technology, 23.06.2019 00:30, hannahrasco4051

Pl i need the answer now ! which one of the following is considered a peripheral? a software b mouse c usb connector d motherboard

Answers: 1

continue

Computers and Technology, 24.06.2019 02:50, rurbanok12

Be sure to answer all parts. synthesize the following compound from benzene. a. b. c. d. e. f. reaction [1] conditions: a b c d e f reaction [1] product: draw structure reaction [2] conditions: a b c d e f reaction [2] product: draw structure reaction [3] conditions: a b c d e f reaction [3] product:

Answers: 3

continue

Do you know the correct answer?

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