in Databases
78 views
0 votes
0 votes

 

In relational databases, the natural join of two tables:

  1. Can be equivalent to cartesian product of these two tables
  2. Is combination of union and filtered cartesian product
  3. Is combination of selection and filtered cartesian product
  4. Is combination of projection and filtered cartesian product

 

MSQ

Please describe your choice(s).

in Databases
78 views

1 Answer

1 vote
1 vote
  1. If No common Attribute between the relations, Natural join between those two relation is  equals to cross product.   
  2. False
  3. False
  4. R Natural Join S is combination of projection and filtered cartesian product.     So according to me a and d are correct.

      

        

Related questions