Answer to Question #145164 in Databases | SQL | Oracle | MS Access for Ankita Sonawane

Question

Consider the following schema ,write the relational algebra queries for the following:
Supplier(sid,name,address)
Parts(pid,name,color)
Catalog (sid,pid,cost)

i)Find sid of supplier who supplies every part)
ii)find the name of suppliers who supplies only red parts.
iii) find the ID’s of suppliers who supplies only red parts.
iv) find the sid of suppliers who supplies only red parts or are at 221 park street.

Answer 1

Dear Ankita Sonawane, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order