Chapter 4, Problem 3PE

Explanation of Solution

a.

To perform an operation equivalent to natural left outer join:

• Initially, use a sub-query to perform just a natural join of the two given tables.
• For each corresponding record, which is missing from takes table, append null values in the relevant attributes and add to the result of natural join...

Explanation of Solution

b.

To perform an operation equivalent to natural full outer join:

• Use a sub-query to perform just a natural join of the two given tables.
• Now, for each corresponding record which is missing from takes table, append null values in the relevant attributes and add them to the result of natural join. In fact, this step is same as in part (a) above. The result is same as natural left outer join.
• Next, for each corresponding record which is missing from student table, append null values in the relevant attributes and add them to the result of natural join...