Question

State the example the difference between cartesian product and natural join

Answer 1

Cross or cartesian product is denoted by X * Y and returns a relation on tuples, whose schema contains all fields of X followed by all fields of Y. Natural join is denoted by '⋈'. It is applicable only when there is atleast one attribute common to R and S.