Relational Algebra

# Question $5.$ Please place a corresponding number $(1,2,3..)$ to connect what each of the following Relational Algebra operations or expressions does $(1$ pt$.$ per correct matching, and one of them is done for you as an example$).$

$\backslash$table$[[1,{}_{\text{p}\text{r}\text{e}\text{d}\text{i}\text{c}\text{a}\text{t}\text{e}}(R)$ # Selection,,$\backslash$table$[[$Return all tuples in R combined $($vertically$)$ with all$],[$tuples in S$.]]],[2,{}_{A,B}(R)$# Projection,$1,$Filter tuples by the predicate and list all columns of R$.],[3,$RUS # Union,,List attributes $A,B$ for all tuples of $R.],[4,$R$$S # Intersection,,$\backslash$table$[[$Combine $($horizontally$)$ tuples in R and S if the predicate$],[$is true.$]]],[5,$R$-$S # Set difference,,Return all tuples that appear in both $R$ and $S.],[6,$RxS # Cartesian product,,Returns tuples in R but not in S$.],[7,R||><msub\; id="EditorElement\_300248"><mrow><mi\; id="EditorElement\_300223">|</mi></mrow><mrow\; id="EditorElement\_300247"><mtext\; id="EditorElement\_300226">p</mtext><mtext\; id="EditorElement\_300228">r</mtext><mtext\; id="EditorElement\_300230">e</mtext><mtext\; id="EditorElement\_300232">d</mtext><mtext\; id="EditorElement\_300234">i</mtext><mtext\; id="EditorElement\_300236">c</mtext><mtext\; id="EditorElement\_300238">a</mtext><mtext\; id="EditorElement\_300240">t</mtext><mtext\; id="EditorElement\_300242">e</mtext><mtext\; id="EditorElement\_300244"></mtext></mrow></msub><mi\; id="EditorElement\_300250">S</mi><mi\; id="EditorElement\_299917">|</mi>$ # Theta join,,$\backslash$table$[[$Combine $($horizontally$)$ every tuple in R with every tuple$],[$in S$.]]],[8,\backslash$table$[[($Student$))],[$# Selection then Projection$]],,\backslash$table$[[$Join $($combine attributes horizontally$)$ tuples $($S$1)$ from$],[$Student relation to tuples $($C$1)$ from Class relation if the$],[$values of the attribute $\frac{c}{s}\frac{?}{d}$ in $S1$ agree with $($are the$],[$same as$)$ the values of the attribute id in C$1.]]],[9,\backslash$table$[[$Student Class.$id$ Class$],[$# Theta join$]],,\backslash$table$[[$Join $($combine attributes horizontally$)$ tuples in Product$],[$and Sale using the attribute$($s$)$ with the same name$($s$)],[$and datatype$($s$)$ and the duplicated attribute$($s$)$ will be$],[$dropped $($keep only one copy of the duplicated$],[$attribute$($s$)).]]],[10,$Student $||><mi\; id="EditorElement\_299328">|</mi><mi\; id="EditorElement\_299099">|</mi>$ Class # Natural Join,,$\backslash$table$[[$Filter the tuples in relation Student by the condition$],[$that GPA is greater than or equal to $3\mathrm{.}0,$ then list all the$],[$names and addresses of the students that satisfy that$],[$condition$.]]]]$