retagged by
412 views

2 Answers

Best answer
7 votes
7 votes
As projection in RA operator  eliminates duplicates automatically so only one tuple will be displayed which is 1 .
selected by
0 votes
0 votes

ΠA(R)  → {1,2}

ΠB(R)  → {1,2}

ΠA(C)  → {1}

So, 

(ΠA(R)×ΠB(R)×ΠC(R)) → {1,2} * {1,2} * {1}

                                        → {(1,1,1),(1,2,1),(2,1,1),(2,2,1)}

 

σA=B and B=C and C=A(ΠA(R)×ΠB(R)×ΠC(R))  → {(1,1,1)}

 

Hence, 1 row will be returned.

Answer:

Related questions

0 votes
0 votes
1 answer
2
1 votes
1 votes
1 answer
4
Bikram asked Aug 26, 2017
403 views
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the max...