Question: (28 points) Q3. 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)

(28 points) Q3. Consider the following schema: Suppliers(sid: integer, sname: string,

(28 points) Q3. 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 names of suppliers who supply every red part. 2. Find the sid of suppliers who supply only red parts. 3. Find the sid of suppliers who supply a red part and a green part, without using INTERSECT. 4. Find the sid of suppliers who charge more for some part than the average price of that 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!

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

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

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

Consider the following schemas: SUPPLIER (sid: integer, sname : string, address : string ) PART ( pid : integer, pname: string, color : string) CATALOG ( sid : integer, pid : integer, cost : real )...

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

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

What is a foreign key constraint? Why are such constraints important? What is referential integrity? ( 1 0 pts ) 2 . Explain the difference between external, internal, and conceptual schemas. How are...

Can anyone solve question 1 until 5 ? constraint in the ER diagram n Question: 3(20 Marks) Consider the following schema: Suppliers (sid: integer, sname: string, address: string) Parts (pid: integer,...

Database Systems Consider the following schema: Suppliers (sid: integer, sname: string, address: string) Parts (pid: integer, pname: string, color: string) Catalog (sid: integer, pid: integer, cost:...

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

Suppose that Dublin city transportation department would like to perform data analysis on motorway traffic for the planning of M50 extension based on the city traffic data collected at different...

Assume the input to the block shown below is r(t) = 10t Write the equivalent differential equation for the system depicted in the block diagram R(s) 54 +25 +35 +5+1 55+55 +85 +25 +35+4 C(s)

Corporate Finance Learning Assessment - Traditional Business Finance - Proffc, Loss, Cash Flow, and Margins Which one of the following companies is most ikely to run into cash flow problems? A A loss...

The following items were selected from among the transactions completed by Shin Co. during the current year: Jan. 10. Purchased merchandise on account from Beckham Co., $144,000, terms n/30. Feb. 9....

d. How will lack of trust be handled?

Are the rules readily available?

Which members would you want back in your team and which would you not?