S(S#,SNAME,STATUS,CITY)

P(P#,PNAME,COLOR,WEIGHT,CITY)

SP(S#,P#,QTY)

Answer the following questions using the query language (Relational Multiple Analysis (TRC), Relational Algebra or SQL) given on the left.

A.[Relational Algebra] Bring at least the vendor names of the vendors providing all parts provided by the S2 vendor.

B.[Relational Algebra] Bring the provider names of providers that provide at least one red piece.

C. [TRC] Bring the supplier names of providers who do not provide the P2 part.

D. [TRC] Bring the vendor names of the vendors that provide all the parts.

E. [SQL] Bring part numbers of parts supplied by more than three suppliers.

F. [SQL] Obtain the average of the total amount of parts