19.4k views
4 votes
Write the following queries in relational algebra: 'Find the sids of suppliers who supply every part.'

User Herr Derb
by
7.3k points

1 Answer

2 votes

Final answer:

To find the sids of suppliers who supply every part, use the division operator in relational algebra.

Step-by-step explanation:

To find the sids of suppliers who supply every part, you can use the concept of division in relational algebra. The division operator is denoted by ÷. Here's how you can write the query in relational algebra:

  1. Select the sids of all suppliers who supply every part: πsid(SUPPLIER ÷ PART)
  2. Retrieve the result of the division query: πsid(SUPPLIER ÷ PART)

User Matti Wens
by
8.0k points