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, par name, color,…

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, par-name, 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 100 and the name of all parts supplied by "RD Traders" c) Find the number of parts supplied by "S02" d) Find the name of suppliers located in city "KTM".