Register

CIL

285 views

2 Answers

0 votes
0 votes

@mohit+jain

(b) projection …..

 

The select, project, and rename operations are called unary operations, because they operate on one relation….

The other three operations i.e. join, Cartesian product and intersection operate on pairs of relations and are, therefore, called binary operations….

 

Example of unary operator:

Π<company = “Google”>(Table_name) …

 

 

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
mohit jain asked Jun 25, 2022
263 views
CIL 2020
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operates on numbers. (a) Relational Calculas (b) Referential Integrity (c) Relational Algebra (d) Relations
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operates on numbers.(...
User Avatar
0 votes
0 votes
1 answer
2
mohit jain asked Jun 25, 2022
193 views
CIL
relations and fields can be renamed in relational algebra using the renaming operator (a) ρ (b) σ (c) ∅ (d) ⟕
relations and fields can be renamed in relational algebra using the renaming operator(a) ρ(b) σ(c) ∅(d) ⟕
User Avatar
0 votes
0 votes
1 answer
4
mohit jain asked Jun 25, 2022
387 views
CIL, UPPCL AE CS 2019
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join operation? (A) 3 (B) 4 (C) 6 (D) 5
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join opera...
User Avatar
Link Copied!