Database Management System - Old Questions

Consider the following employee database, where primary keys are underlined

Supplier(supplier-id, supplier-name, city)

Suppliers (Supplier-id, parts-id, quantity)

Parts(part-id, color, weight)

a) Write a SQL query to create above table.

b) Find the name of all suppliers who has supplied parts with quantity more than 10.

c) Find the name of all parts supplied by "RD Traders"

d) Find the number of parts supplied by "SO2".

e) Find the name of all suppliers located in the city "KTM".