Register

consider relation R1(A,B) and R2(C,D) ,where R1 contain 'm' tuples and R2 contain 'n' tuples and R1,R2 contain no common attribute and attribute B have NULL values then what is the number of tuples in cartesian product of R1 and R2?

882 views

1 Answer

1 votes
1 votes
i think its mxn.. I find no reason why  null make a difference
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
2 answers
1
Sara asked Dec 24, 2015
6,904 views
Given two R union compatible relation R1 (A, B) and R2 (C, D) what is the result of the operation
Given two R union compatible relation R1 (A, B) and R2 (C, D) what is the result of the operation R1 A= C AB = D R2? a) R1⋃R2 b) R1 ⨯ R2 c) R1 – R2 d) R1 ∩R2 How to solve these kind of questions
Given two R union compatible relation R1 (A, B) and R2 (C, D) what is the result of the operationR1 A= C AB = D R2?a) R1⋃R2 b) R1 ⨯ R2 ...
User Avatar
6 votes
6 votes
5 answers
2
learncp asked Sep 5, 2015
5,242 views
GATE2004_13 Let R1 (A, B, C) and R2 (D, E) be two relation schema, where the primary key...
----SPOILERS------ My doubt is that why option "c" shouldnt be an answer, as join is performed on the C not equal to D, and there will be no case where C is not equal to d as it satisfies referential integrity constraints. . ?
SPOILERS My doubt is that why option "c" shouldnt be an answer, as join is performed on the C not equal to D, and there will be no case where C is not equal to d as i...
User Avatar
1 votes
1 votes
1 answer
3
Shefali asked Jul 23, 2015
4,832 views
A relation R(ABCDE) with FD set f = {A -> BC, C -> DE, D -> E} and the decomposition d = { R1(ABCD), R2(DE)}. Is this decomposition dependency preserving?
The answer given is YES. But how is the dependency C - DE preserved in this decomposition?
User Avatar
Link Copied!