Register

Recent questions tagged natural-join

0 votes
0 answers
3
Natural Join Self Doubt
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
User Avatar
0 votes
1 answer
6
Natural Join
Suppose we have 2 tables R1(ABCD), R2(DE) . R1 has 500 entries whereas R2 has 1500 entries. Here D is a candidate key. If we join them using natural join. How many entires would be there in the resultant table and why ? Examples would be appreciated..
Suppose we have 2 tables R1(ABCD), R2(DE) . R1 has 500 entries whereas R2 has 1500 entries. Here D is a candidate key. If we join them using natural join. How many entire...
User Avatar
0 votes
0 answers
8
Database Management System
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ?? a. Empty relation. b. Cartesian Product of the relations.
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ??a. Empty relation.b. Cartesian Product of the relations.
User Avatar
1 votes
1 answer
9
Database
consider $r1(A,B,C),r2(C,D,E)$ and $r3(F,G)$ with primary key $A,C,F, r1$ has $150 ,r2$ has $100$ and $r3$ has $75$ tuples the number of tuples in $r1$ natural join $r2$ natural join $r3?$
consider $r1(A,B,C),r2(C,D,E)$ and $r3(F,G)$ with primary key $A,C,F, r1$ has $150 ,r2$ has $100$ and $r3$ has $75$ tuples the number of tuples in $r1$ natural join $r2$ ...
User Avatar
0 votes
0 answers
10
JOIN Doubt
in case of outer join for combining two tables, if there is no common attribute does it returns cartesian product just like natural join does?
in case of outer join for combining two tables, if there is no common attribute does it returns cartesian product just like natural join does?
User Avatar
0 votes
1 answer
11
#book
A B C 1 a c 2 b b 3 c a 4 c c A B D 1 a a 1 b b 3 c c 4 c d these are two table R AND S FIND NATURAL JOIN(*)
ABC1ac2bb3ca4ccABD1aa1bb3cc4cd these are two table R AND S FIND NATURAL JOIN(*)
User Avatar
5 votes
1 answer
15
MadeEasy Test Series: Databases - Natural Join
Consider a relation r1(A, B, C), r2(C, D, E) and r3(F, G) with primary keys A, C and F respectively. Assume that r1 has 150 tupples, r2 has 100 tupples and r3 has 75 tupples. The number of resultant tuple in are ________.
Consider a relation r1(A, B, C), r2(C, D, E) and r3(F, G) with primary keys A, C and F respectively. Assume that r1 has 150 tupples, r2 has 100 tupples and r3 has 75 tupp...
User Avatar
0 votes
2 answers
17
Theta Join
When we do natural join say between R1(A,B,C) and R2(A,B,D) we get new Relation as ---> R(A,B,C,D) Say if we do Theta join using a Predicate P then the result will be ----> R(A,B,C,A,B,D) Am i right?
When we do natural join say between R1(A,B,C) and R2(A,B,D) we get new Relation as - R(A,B,C,D)Say if we do Theta join using a Predicate P then the result will be R...
User Avatar
1 votes
1 answer
20
Natural join
My answer is not matching with any of the option.so what is the correct answer
My answer is not matching with any of the option.so what is the correct answer
User Avatar
3 votes
2 answers
25
#DBMS What will be the Minimum Number of Tuples?
Say we have two relations R (a,b,c) and S (b,d,e). Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Join)?
Say we have two relations R (a,b,c) and S (b,d,e).Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Joi...
User Avatar
2 votes
1 answer
26
#DBMS Natural Join
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!
User Avatar
1 votes
0 answers
27
DBMS SELF DOUBT
Let R and S be two relations with the following schema R(P−−,Q−−,R1,R2,R3) S(P−−,Q−−,S1,S2) where {P,Q} is the key for both schemas? R:{⟨"1","abc","p1","p2","p3"⟩, ⟨"2","xyz", ... ;,"q3"⟩ ⟨"2","def","q1","q2","q3"⟩ WHat is R *S? WHERE * IS NATURAL JOIN.
Let R and S be two relations with the following schemaR(P−−,Q−−,R1,R2,R3)S(P−−,Q−−,S1,S2)where {P,Q} is the key for both schemas?R:{⟨"1","abc","p1","p2"...
User Avatar
3 votes
1 answer
28
Database: equijoin v/s natural join
Which one is the more suitable answer for the following question, equijoin or natural join?
Which one is the more suitable answer for the following question, equijoin or natural join?
User Avatar
0 votes
0 answers
29
equi natural inner join
Can we say inner and self join are same ?
Can we say inner and self join are same ?
User Avatar
2 votes
2 answers
30
Block Nested Loop Join
Consider a relation R with 2000 records and relation S with 500 records. Size of each record is 5 Byte and block size is 100 Byte, then minimum number of block access that are needed block nested loop join. I think its answer should be 2525.
Consider a relation R with 2000 records and relation S with 500 records. Size of each record is 5 Byte and block size is 100 Byte, then minimum number of block access tha...
User Avatar
Page: