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\_2730167"><mrow><mi\; id="EditorElement\_2730142">|</mi></mrow><mrow\; id="EditorElement\_2730166"><mtext\; id="EditorElement\_2730145">p</mtext><mtext\; id="EditorElement\_2730147">r</mtext><mtext\; id="EditorElement\_2730149">e</mtext><mtext\; id="EditorElement\_2730151">d</mtext><mtext\; id="EditorElement\_2730153">i</mtext><mtext\; id="EditorElement\_2730155">c</mtext><mtext\; id="EditorElement\_2730157">a</mtext><mtext\; id="EditorElement\_2730159">t</mtext><mtext\; id="EditorElement\_2730161">e</mtext><mtext\; id="EditorElement\_2730163"></mtext></mrow></msub><mi\; id="EditorElement\_2730169">S</mi><mi\; id="EditorElement\_2730026">|</mi>$ # Theta join,,$\backslash$table$[[$Combine $($horizontally$)$ every tuple in R with every tuple$],[$in $5.]]],[8,\backslash$table$[[$ GPA $3\mathrm{.}0($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 clsld in S$1$ agree with $($are the$],[$same as$)$ the values of the attribute id in C$1.]]],[9,\backslash$table$[[$Student Classid 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\_2729288">|</mi><mi\; id="EditorElement\_2729059">|</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$.]]]]$