Register

CIL

326 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

282
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
282 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
212
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
212 views
CIL
relations and fields can be renamed in relational algebra using the renaming operator(a) ρ(b) σ(c) ∅(d) ⟕
User Avatar
268
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
268 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
427
views
1 answers
0 votes
mohit jain asked Jun 25, 2022
427 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!