|
Answer» In Relational Algebra, one operand OPERATIONS are known as unary operations. The procedures PROJECTION, SELECTION, and RENAME are unary operations in relational algebra: - The SELECT operation: The SELECT operation SELECTS a subset of tuples from a relation that fulfils a set of criteria. The SELECT operation is a FILTER that keeps only those tuples that fulfil a set of criteria. Alternatively, you MAY use the SELECT method to limit the tuples to those that fulfil the criteria. The SELECT operation can be thought of as dividing the relation horizontally into two groups of tuples: those that meet the criteria and are selected, and those that do not and are rejected.
- The PROJECT operation: If a relation is viewed as a table, the SELECT operation selects certain rows while discarding others. In contrast, the PROJECT operation selects a subset of the table's columns while rejecting the remainder. We can use the PROJECT operation to project a relation over just a few of its attributes if we're just interested in a few of them. As a result, the result of the PROJECT operation can be viewed as a vertical partition of the relation into two relations: one with the needed columns (attributes) and the operation's result, and the other with the rejected columns.
- The RENAME operation: It is occasionally SIMPLE and suitable to break a complicated chain of operations and rename it as a relation with new names. Renaming a relationship can be done for a variety of reasons, including:
- It is possible that we'll want to save a relation as the result of a relational algebra expression.
- It is possible that we'll want to join a relation to itself.
|