Consider the given relational database schema:
SUPPLIER(SupplierNo, SupplierName, SupplierCity)
PART(PartNo, PartName, Weight, Quantity, Color)
SUPPLY(SupplierNo, PartNo, Quantity)
Q1. prepare down the SQL DDL definition for the above schema.
Q2. Deduce the given queries in SQL:
a) Find out the names of parts that are supplied through more than one supplier.
b) Find out the name of suppliers who have supplied all the red colored parts.
c) Find out the names of supplier who has supplied blue parts more than the average number of blue parts supplied by the supplier in same city.
d) Find out the names of supplier who supply at least two parts.
e) Delete the Suppliers who have supplied no parts.