RDBMS RELATIONAL ALGEBRA

______ notation used to represents projection operation

• π

• Sigma

• -

• X

_______ operation used to retrieve the common tuple values from two relations

• Union

• Intersect

• Difference

• Cartesian product

UNION ALL represents what??

• It allows all the duplicate values

• It rejects all the duplicate values

Every tuple in one relation must be related with every tuple of another relation is known as ______

• Union

• Intersect

• Cartesian product

• Projection

The notation p refers to _____

• Natural Join

• Rename

• Union

• None

R1 |×| c (R2) represents _____

• Condition join

• Natural join

• Both

• None

R1 |x| R2 represents _____

• Cartesian product

• Natural join

• Equi join

• Condition join

The notation for division operation is _____

• /

• ÷

• -

• X

Sigma notation used to represent ______ operation

• Selection

• Projection

• Difference

• Cartesian product

Choose the correct option from the following..

• ( Employee) = π ( eid,ename )

• π (eid, ename)

• Employee ( πeid, πename)

• None