Register

HCU PHD 2019 May

1,945 views

1 Answer

1 votes
1 votes

Relational algebra has $6$ basic relational operation.

  1. Select $(\sigma )$
  2. Project $(\pi )$
  3. Union $(\cup )$
  4. Set difference$(-)$
  5. Cartisian product $(\times )$
  6. Rename $(\rho )$

Other Operations like Divide $(/)$ can be derived using the basic 6 operators.

So,Only option (D) has derived operator , So Correct answer is option (D).

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

Related questions

0 votes
0 votes
0 answers
1
mohit jain asked Jun 25, 2022
349 views
HCU PHD 2018 JUNE
Suppose there are three relations as given below: (x) R(a,b)= (0,1),(4,5),(8,9). (y) S(b,c )=(1,2),(5,2),(5,6),(5,10),(13,10). (z) T( c,d)=(2,3),(6,7)(10,11),(10,3) the number of tuples in (R * S) * T, where * is the full natural outer join, is: (a) 5 (b) 8 (c) 13 (d) 60
Suppose there are three relations as given below:(x) R(a,b)= (0,1),(4,5),(8,9).(y) S(b,c )=(1,2),(5,2),(5,6),(5,10),(13,10).(z) T( c,d)=(2,3),(6,7)(10,11),(10,3)the numbe...
User Avatar
0 votes
0 votes
1 answer
2
mohit jain asked Jun 25, 2022
386 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
32 votes
32 votes
2 answers
3
Arjun asked Feb 7, 2019
14,312 views
GATE CSE 2019 | Question: 55
Consider the following relations $P(X,Y,Z), Q(X,Y,T)$ and $R(Y,V)$ ... Answer: ________
Consider the following relations $P(X,Y,Z), Q(X,Y,T)$ and $R(Y,V)$.$$\overset{\textbf{Table: P}}{\begin{array}{|l|l|l|} \hline \textbf{X} & \textbf{Y} & \textbf{Z} \\\hli...
User Avatar
–1 votes
–1 votes
0 answers
4
Himanshu Kashyap asked Jan 12, 2019
664 views
MadeEasy Test Series 2019: Databases - Relational Algebra
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
User Avatar
Link Copied!