Consider the following schema: Suppliers(sid: integer, sname: string, address: string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer, price: real) The Suppliers relation describes suppliers of parts. The Parts relation contains information about each part. The Catalog relation lists the prices in dollars charged for parts by suppliers. (The keys are underlined: sid is a key for Suppliers, (sid,pid) is a key for Catalog, and pid is a key for Parts.)

Write the following queries using SQL.

a) Print all the catalog records for red parts.

b) Find the names of the most expensive parts supplied by suppliers named `Santa Claus.

c) Find the sids and snames of all the suppliers that supply at least two different parts.

d) For each supplier from (2), print its name and the cost of the least expensive part that supplier carries.

e) Find the sids of suppliers who supply all the blue parts.