Advanced Database Management System - Tutorials and Notes: Binary operations in relational algebra

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Wednesday, 7 September 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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents