TOPICS (Click to Navigate)

Pages

Wednesday, September 7, 2016

Binary operations in relational algebra

Which of the following operations are binary operations in relational algebra?


Question:


3. Which of the following operations are binary operations in relational algebra?

(a) Projection
(b) Union
(c) Cartesian Product
(d) Rename



Answer:

(b) Union and (c) Cartesian product

Binary operations are operations that are having two operands. For example, in A U B, A and B are operands and U is operation. (Πcname(Customer))U(Πcname(CPhone)) is an union operation between two relational algebra expressions.

Projection and Rename operations are Unary operations involving only one relation as operand.







         Previous Question                                                                                Next Question


No comments:

Post a Comment