Question: BASIC SQL. Consider the following schema: Suppliers ( sid: integer, sname: string, address: string ) Parts ( pid: integer, pname: string, color: string ) Catalog

BASIC SQL.

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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 key...

Q:

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID:integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Q:

EXERCISE 1 (SQL Queries) Consider the following schema: SUPPLIERS (SID : integer, SNAME : string, CITY : string) PARTS (PID : integer, PNAME : string, COLOR : string) CATALOG (SID : integer, PID :...

Q:

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Q:

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Q:

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Q:

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Q:

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string PARTS (PID:Integer, PNAME: string. COLOR: string) CATALOG (SID:integer. PID: integer....

Q:

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)...

Q:

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 key...

Q:

ASC 842 is limited to leases of property, plant and equipment, including subleases of those assets (FASB, 2019). The new standard does not apply to leases of intangible assets, leases on biological...

Q:

Evaluate the convolution integral for a system with input x(t) and impulse response h(t), given by x(t)=u(t-1)-u(t-3) h(t)=u(t)-u(t-2)

Q:

18. In the figure below, AB and CD are chords of the circle with centre O. The point Plies on AB such that AP = BP and the point Q lies on CD such that OQ is perpendicular to CD. Given that AB = 22...

Q:

What is the pH of a solution containing 0.4OM HCOOH (Ka 18x10-4) and 0.6M HCOOK? For the toolbar, press ALT-F100PC) or ALT-FN-F10 Mac BIVS Peragraon Arial 10pt a XX. v 4 T. DO N D

Q:

How are Work Breakdown Statements Built and how do they appear in a Project Plan?

Q:

What is the most important part of any HCM Project Map and why?

Q:

What is the Phase that begins after Project rollover and what activities are part of the Phase?