in Databases
94 views
0 votes
0 votes
in relational databases, the natural join of two tables is

(a) cartesian product always

(b) combination of union and filtered cartesian product

(c) combination of selection and filtered cartesian product

(d) combination of projection and filtered cartesian product
in Databases
94 views

1 Answer

1 vote
1 vote

Natural join is used to join two relations having any number of attributes. It is denoted by a symbol ( ⨝).

It is the combination of projection and filtered cartesian product.

Ref: https://stackoverflow.com/questions/14127306/relational-algebra-cartesian-product-vs-natural-join

Related questions