Show how to sort-join the relations CSG from Fig. 8.1 and SNAP from Fig. 8.2(a) by sorting the merged list of tuples as in Example 8.16. Assume the natural join, or equality on the Student Id components, is wanted. Show the result of the sort, analogous to Fig. 8.17, and give the tuples in the result of the join.
Fig. 8.1. A table of information.
Fig. 8.2. Sample relations.
Fig. 8.17. Sorted list of tuples from CDH and CR.