Register

CIL

329 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

283
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
283 views
CIL 2020
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which ... Relational Calculas(b) Referential Integrity(c) Relational Algebra(d) Relations
User Avatar
214
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
214 views
CIL
relations and fields can be renamed in relational algebra using the renaming operator(a) ρ(b) σ(c) ∅(d) ⟕
User Avatar
270
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
270 views
CIL Part B
Consider the following relation schema R and S along with their tuple sets.R(A, B) = { <a1, b1 >, <a2, b1>, <a3, b1>, <a4, b1 ... b2, b4}B. T(B) = {b1, b3, b4}C. T(B) = {b1, b4)D. T(B) = {b1, b3}
User Avatar
428
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
428 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
User Avatar
Link Copied!