I have a question regarding the resulting attributes in the cross product of two relations in relational algebra...
Generally, the cross product will result in a relation whose attributes is the sum of all the attributes, So number of attributes in
R1 x R2 will be attributes in
R1 + R2, so
R1(a, b, c) x R2(d, e, f) →
R(a, b, c, d ,e ,f)...
But, what happens if
R2 have common attributes (attributes of the same name)? since a relation can not have duplicate attributes... so what would happen in the case
R1(a, b, c) X R2(a, e, f)? thanks...