Machine-translated by Google. Questions are authored in English.
Top

Discussion

In Relational Algebra, which operator is NOT primitive but derived ?

  • A.Selection
  • B.Projection
  • C.Join
  • D.Cartesian Product

Answer: C

The derived operator is Join.

The primitive (fundamental) operations of relational algebra are selection, projection, union, set difference, Cartesian product and rename. A join is not one of them, because it can be written in terms of them: a theta join is a selection applied to a Cartesian product, and a natural join adds a projection to remove the duplicate columns.

Selection, projection and Cartesian product are all primitive, so none of them is the answer.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.