Database Management System - Old Questions

4.Consider the following supplier database, where primary keys are underlined:(20)

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

Supplies (supplier-id, part-id, quantity)

Parts (part-id, part-name, color, weight)

Construct the following relational algebra queries for this relational database

a)Find the name of all supplies located in city "Kathmandu".

b) Find the name of all parts supplied "ABC Company".

c)Find the name of all parts that are supplied in quantity greater than 300.

d)Find the number of parts supplied by "ABC Company'.

e)Find the name of all suppliers who supply more than 30 different parts