We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
I can't understand that in how the tuples are represented here in the relation R. How is it possible to have different tuples in one relation?
If I take R(B,C,D) that means relation R has three attributes i.e., B,C and D
so what does it mean
B:C:D
50,1,6
so does it mean that the attribute B has 50 tupples,attribute C has 1 tupple and the attribute D has 6 tupples?
Databases - Natural Joins
You are viewing a single comment's thread. Return to all comments →
I can't understand that in how the tuples are represented here in the relation R. How is it possible to have different tuples in one relation? If I take R(B,C,D) that means relation R has three attributes i.e., B,C and D so what does it mean B:C:D 50,1,6 so does it mean that the attribute B has 50 tupples,attribute C has 1 tupple and the attribute D has 6 tupples?
yes b:c: have 50:1:6 tuple
The tuple representing the shared properties of tables R and S (their values for A,B,C, and D fields) was {A:27, B:50, C:1, D:6}
You can see this finding the equality (both = 1) in the C field, between A:C and B:C:D.