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

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 ) The primary key fields are underlined, and the domain of each field is listed after the field name. The CATALOG schema lists the prices charged for PARTs supplied by SUPPLIERs. Write the equivalent SQL expression for the following: pid((color=redcolor=green)(PARTCATALOG))
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
