Register

relational algebra

504 views
2 votes
2 votes
THE DIFFERENCE BETWEEN FOLLOWING 2 EXPRESSIONS?

a. (selection)year≥2009(takes) NATURAL JOIN  student
b. (selection)year≥2009(takes NATURAL JOIN student)
User Avatar

1 Answer

Best answer
5 votes
5 votes

If takes and student are the relation table then  query a. first selects the tuple and then performs the NATURAL JOIN

while in query b. NATURAL JOIN is done first and then from resultant the tuples are selected satisfying the condition of selection

• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
Ashutosh_17 asked Mar 30, 2023
941 views
Database: Relational Algebra
Let R be a relation of degree 5 then the total number of projections possible on R is ___?
Let R be a relation of degree 5 then the total number of projections possible on R is ___?
User Avatar
3 votes
3 votes
1 answer
4
Hirak asked May 25, 2019
2,143 views
MADE EASY Relational Algebra
In a relational algebra ∩ is not a basic operator, to make it basic only relational operator we should have are X, – X, U U, –
In a relational algebra ∩ is not a basic operator, to make it basic only relational operator we should have areX, – X, UU, –
User Avatar
Link Copied!