Ask Question
29 February, 19:07

Consider the following schema:Suppliers (sid: integer, sname: varchar, address: varchar) Parts (pid: integer, pname: varchar, color: varchar) Catalog (sid: integer, pid: integer, cost: real) Where sid is the supplier's id (primary key in Suppliers), pid is the part's id (primary key in Parts), and sid together with pid is the primary key of Catalog. The Catalog relation lists the prices charged for parts by Suppliers. A) Write the following queries using relational algebra:5 Find the sids of suppliers who supply every part6. Find the sids of suppliers who supply every red part7. Find the sids of suppliers who supply every red or green part. 8. Find the sids of suppliers who supply every red part or supply every green part

+3
Answers (1)
  1. 29 February, 21:13
    0
    umm lemme check
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Consider the following schema:Suppliers (sid: integer, sname: varchar, address: varchar) Parts (pid: integer, pname: varchar, color: ...” in 📙 Engineering if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers