Question

Construct the table obtained by applying the join operator \({J_2}\) to the relations in Tables 9 and 10.

Short answer

The resultant answer isexplained.

Step-by-step solution

Given data

Table 9 and 10is given.

Concept ofsets

The concept of set is a very basic one.

It is simple; yet, it suffices as the basis on which all abstract notions in mathematics can be built.\(A\)set is determined by its elements.

If\(A\)is a set, write\(x \in A\)to say that\(x\)is an element of\(A\).

Simplify the expression

To find rows of Table 9, the last two entries of which are identical to the first two entries of rows of Table 10.

Combine each such pair of rows into one row of our new table. For instance, the last two entries in the first row of Table 9 are 1092 and 1.

The first two entries in the second row of Table 10 are also 1092 and 1.

Therefore, combine them into the row 23,1092,1,2,2 of our new table, whose columns represent Supplier, Part number, Project, Quantity, and color code.

The new table consists of all pairs found in this way. (Supplier, Part number, Project, Quantity, Color code)