Consider the database:

Supplier$($Sno$,$ Sname, City,rating$)$

Parts$($partno$,$ partname,weight,color$)$

Catalog$($Sno$,$ Partno, Qty$,$ Price, shipmentdate$)$

Write queries in RA

$1.$ Get partnames that are supplied entirely by one supplier whose rating is greater than

supplier $$S$1$

$2.$ For each part supplied to each supplier located at Mumbai, get the part number and

shipment weight.

For the above mentioned database, write queries in SQL:

$1.$ Find the supplier names of suppliers that supply at least those parts that are supplied by any

supplier in Mumbai.

$2.$ Find the shipment weight and date for every red or blue part supplied by every supplier.

$3.$ Get part names for parts supplied to all projects in Mumbai.