in Databases
379 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
379 views

2 Answers

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

0 votes
0 votes
(d) combination of projection and filtered Cartesian product

projection operation is required to filter to duplicate column because in natural join same attribute column is merged into one.

filtered Cartesian operation is required to filter to selected tuples.

Related questions