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

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)

answered
User Matti Wens
by
8.4k points
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.