The Project operation in relational algebra is denoted by:

π <list1> (π <list2>)(R)) =π<list1>(R) as long as <list2> contains the attributes in <list1>

commutativity does not hold on PROJECT

The Cardinality of the relation resulting from a Project operation is …........... the cardinality of R.

πList1 (πList2 (...(πListn(R))...) ) = πList1(R)

Which Relational algebra expression is correspond to the following SQL query:

The result of the ……….operation can be visualized as a vertical partition of the relation into two relations.

σ<cond1>(σ<cond2>(σ<cond3>(R))) is equivalent to

The RENAME operation in relational algebra is denoted by:

RENAME operation which can rename either the relation name or the attribute names, or both is a unary operator

ρS(R)

ρ(B1, B2, ..., Bn)(R)

ρS(B1, B2, ..., Bn)(R)

Renaming in SQL is accomplished by using

Relational set operators are used to combine or subtract the records from two tables

RELATIONAL SET OPERATORS is

RELATIONAL SET OPERATORS are used for doing set operations on relations having same schema.

...... , is a relation that includes all tuples that are either in R or in S or in both R and S. Duplicate tuples are eliminated

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

IN UNION Duplicate tuples are allowed.