JOIN

Binary Relational Operations : RENAME (ρ)

CARTESIAN PRODUCT ( x )

The relation resulting from the SELECT operation has the ........ attributes as R.

The symbol σ (sigma) is used to denote the project operator

The SELECT operator is unary; that is, it is applied to a single relation.

The number of tuples in the resulting relation is always............. to the number of tuples in R

a sequence of SELECTs can be applied in any order

The ............... operation, selects certain columns from the table and discards the other
columns.

the result of the PROJECT operation can be visualized as a vertical partition of the relation into two relations

The general form of the PROJECT operation is

The result of the PROJECT operation has only the attributes specified in <attribute list> in the same orde they appear in the list.

PROJECT degree ........... the number of attributes in < attribute list >.

The number of tuples in a relation resulting from a PROJECT operation is always less than or equal to the number of tuples in R.

In SQL, the PROJECT attribute list is specified in the SELECT clause of a query

commutativity does hold on PROJECT .

Renaming in SQL is accomplished by using ...

Relational set operators are used to combine or subtract the records from two tables, so they are also binary set operators

They are used for doing set operations on relations having different schema

In order to set operators to work in database, it should have ........... number of columns participating in the query and the datatypes of respective columns should be ...........

SET DIFFERENCE : The result of this operation, denoted by R – S, is a relation that includes all tuples that are in S but not in R .