Chapter 2, Problem 5PE

Explanation of Solution

Effect of Cartesian product on two relations:

• The Cartesian product operation (×) is used to combine the information from two relations.
• The Cartesian product of two relations r1 and r2 can be written like,

  r1 × r2.

  For the given relations we can write,

  (Student × advisor)

• In the above operation, all the tuples from both the relation is taken and a new relation is created with all the tuples.
• If there is similar column names like “id” in both the relation, then the column name along with the relation name. For example,

  student.id and advisor.id

The join operation:

• The join operation is used to select the common tuples from two relations...