Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged natural-join
1
votes
1
answer
31
Natural Join
What will be the output of Natural Join if there is(are) common attribute(s) in two relations but no common value in these common attribute(s) ? for example Table R A B 6 9 7 1 Table S B C 7 3 5 8 R Natural Join s will be ?
What will be the output of Natural Join if there is(are) common attribute(s) in two relations but no common value in these common attribute(s) ?for exampleTable RAB6971Ta...
rdfan19
467
views
rdfan19
asked
Aug 4, 2017
Databases
databases
natural-join
+
–
3
votes
2
answers
32
Natural Join
What will be the output of Natural join if there is(are) common attribute(s) in two relations but no Common value in these common attribute(s) ? For example Table R A B 9 7 6 9 Table S B C 4 1 8 5 Output of R natural join S will be ?
What will be the output of Natural join if there is(are) common attribute(s) in two relations but no Common value in these common attribute(s) ?For example Table RAB9769T...
rdfan19
3.1k
views
rdfan19
asked
Aug 4, 2017
Databases
databases
natural-join
+
–
2
votes
1
answer
33
[DBMS] Number of tuples in RA
rahul sharma 5
1.0k
views
rahul sharma 5
asked
Jul 5, 2017
Databases
databases
relational-algebra
natural-join
+
–
4
votes
4
answers
34
Join Number of Tuples
Suppose you are given relations r(A, B) and s(A, C). Suppose that r has 10000 tuples, and s has 5000 tuples. Suppose attribute r.A has 1001 distinct values, and s.A also has 1001 distinct values. The maximum possible size of the join result is
Suppose you are given relations r(A, B) and s(A, C). Suppose that r has 10000 tuples, and s has 5000 tuples. Suppose attribute r.A has 1001 distinct values, and s.A also ...
kauray
3.7k
views
kauray
asked
May 9, 2017
Databases
natural-join
databases
relational-algebra
+
–
0
votes
0
answers
35
ISI-JRF
Consider the relations r1(A, B, C), r2(C, D, E) and r3(E, F). Assume that the set of all attributes constitutes the primary keys of these relations, rather than the individual ones. Let V (C, r1) be 500, V (C, r2) be 1000, V (E, r2) be ... has 1500 tuples, and r3 has 750 tuples, then give the ordering of the natural join of r1, 2 and r3 for its efficient computation. Justify your answer.
Consider the relations r1(A, B, C), r2(C, D, E) and r3(E, F). Assume that the set of all attributes constitutes the primary keys of these relations, rather than the indiv...
kauray
576
views
kauray
asked
Apr 20, 2017
Databases
sql
natural-join
databases
+
–
0
votes
1
answer
36
self doubt
If there are no attributes in common between two relations R and S then, what should be the result of (R natural join S)? 1) R x S 2) $\phi$ I think option 2 because of following definition from Korth:
If there are no attributes in common between two relations R and S then, what should be the result of (R natural join S)?1) R x S2) $\phi$I think option 2 because of foll...
Sushant Gokhale
381
views
Sushant Gokhale
asked
Feb 3, 2017
Databases
natural-join
+
–
0
votes
1
answer
37
No of tuples
Ans given: 100
Ans given: 100
vaishali jhalani
896
views
vaishali jhalani
asked
Jan 11, 2017
Databases
databases
natural-join
+
–
2
votes
1
answer
38
Natural vs conditional join dbms
Say I have two tables and they have some attributes in common, assume x is common, now will x will appear once in the output or twice for following cases? Natural join Cross product Conditional join Please explain.
Say I have two tables and they have some attributes in common, assume x is common, now will x will appear once in the output or twice for following cases? Natural joinCro...
rahul sharma 5
974
views
rahul sharma 5
asked
Jan 5, 2017
Databases
natural-join
databases
relational-algebra
+
–
3
votes
2
answers
39
Test by Bikram | Databases | Test 1 | Question: 22
Consider the following set of relations: EMP(eno, ename, dno) DEPT(dno,dname) Primary key columns are in bold and dno in EMP is a foreign key referring primary key of DEPT table. Now consider the following queries: QUERY : 1 SELECT * FROM emp e ... Query:1 and Query:2 returns different no of columns. I, II only I, IV only II, III only III, IV only
Consider the following set of relations: EMP(eno, ename, dno)DEPT(dno,dname)Primary key columns are in bold and dno in EMP is a foreign key referring primary key of DEP...
Bikram
678
views
Bikram
asked
Nov 26, 2016
Databases
tbb-dbms-1
natural-join
+
–
0
votes
0
answers
40
gate Exam
Sayan Das 1
217
views
Sayan Das 1
asked
Nov 23, 2016
Databases
natural-join
+
–
8
votes
3
answers
41
Number of tuples in natural join
Consider the following relations: $R_1(A,B,C)$ and $R_2(A,D,E)$. $R_1$ has 1000 records and $R_2$ has 2000 records. The attribute $A$ in $R_2$ is referencing attribute $A$ in $R_1$. Let $X$ be minimum number of records in $R_1$ ⨝ $R_2$ and $Y$ be the maximum number of records in $R_1$⨝$R_2$. The sum of $(X+Y)$ is _______.
Consider the following relations: $R_1(A,B,C)$ and $R_2(A,D,E)$. $R_1$ has 1000 records and $R_2$ has 2000 records. The attribute $A$ in $R_2$ is referencing attribute $A...
GateAspirant999
11.1k
views
GateAspirant999
asked
Oct 31, 2016
Databases
natural-join
databases
relational-algebra
+
–
1
votes
1
answer
42
Nested loop join vs blocked nested loop join
If - relation r has br blocks and nr records, - relation s has bs blocks and ns records, - memory can hold exactly one block of r and one block of s at any point in time, then what is the formula for number block accesses required ... (a) nested loop join (b) blocked nested loop join Also which book discusses this topic? And is it in syllabus for gate?
If- relation r has br blocks and nr records,- relation s has bs blocks and ns records,- memory can hold exactly one block of r and one block of s at any point in time,the...
GateAspirant999
2.0k
views
GateAspirant999
asked
Oct 30, 2016
Databases
natural-join
+
–
1
votes
2
answers
43
Natural join
Q1. Suppose in an SQL query I have natural join as : from R1 natural join R2 natural join R3 natural join R4 then how does the natural join works? According to me, First R1 joins with R2 matching common attributes value between R1 and R2 then the ... such as name and course_id, without the relation names " but teaches.course_id is used in the query. WHY? It's not allowed.
Q1. Suppose in an SQL query I have natural join as : from R1 natural join R2 natural join R3 natural join R4then how does the natural join works? According to me, ...
Shivam Chauhan
917
views
Shivam Chauhan
asked
Oct 20, 2016
Databases
natural-join
databases
+
–
5
votes
2
answers
44
Joining
KISHALAY DAS
1.4k
views
KISHALAY DAS
asked
Oct 19, 2016
Databases
natural-join
referential-integrity
+
–
2
votes
2
answers
45
UGC NET CSE | August 2016 | Part 3 | Question: 9
Suppose database table $T1(P, R)$ currently has tuples ${(10, 5), (15, 8), (25, 6)}$ and table $T2 (A, C)$ currently has ${(10, 6), (25, 3), (10, 5)}$. Consider the following three relational algebra queries $RA1, RA2$ and $RA3$: ... RA2 and RA3 are given by : $2, 4, 2$ respectively $2, 3, 2$ respectively $3, 3, 1$ respectively $3, 4, 1$ respectively
Suppose database table $T1(P, R)$ currently has tuples ${(10, 5), (15, 8), (25, 6)}$ and table $T2 (A, C)$ currently has ${(10, 6), (25, 3), (10, 5)}$. Consider the follo...
makhdoom ghaya
2.9k
views
makhdoom ghaya
asked
Sep 30, 2016
Others
ugcnetcse-aug2016-paper3
databases
natural-join
+
–
0
votes
1
answer
46
join
Comment on the following two statements Natural Join produce cartecian product of two tables on joing two relations with no matching coloums Full Outer Join produce cartecian product of two tables on joing two relations with no matching coloums
Comment on the following two statementsNatural Join produce cartecian product of two tables on joing two relations with no matching coloumsFull Outer Join produce cartec...
pC
497
views
pC
asked
Sep 9, 2016
Databases
databases
natural-join
+
–
8
votes
1
answer
47
Question on Join
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,40,80 respectively. Maximum size of R1*R2*R3 where * denotes natural join.
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,4...
Aakash Das
1.8k
views
Aakash Das
asked
Jun 25, 2016
Databases
databases
natural-join
+
–
3
votes
2
answers
48
maximum no of tuples
Consider the relation R1( P, Q, R, S ) and R2 ( R, G, T, U ) The relation R1 has 20 tuples and R2 has 10 tuples then maximum number of tuples in R1 ⟕ R2 is .......................?
Consider the relation R1( P, Q, R, S ) and R2 ( R, G, T, U )The relation R1 has 20 tuples and R2 has 10 tuples then maximum number of tuples in R1 ⟕ R2 is ...........
saket nandan
2.3k
views
saket nandan
asked
Mar 21, 2016
Databases
relational-algebra
databases
query
natural-join
+
–
1
votes
2
answers
49
dbms
Consider the relation $R(X Y Z)$ has the following tuples X Y Z 1 2 3 1 2 4 3 2 1 _________ tuples in the result of following relational algebra expression $(\underset{X,Y}\pi R ) \underset{R,Y < S,Y}\bowtie (\underset{S(X,Y)}\rho (\underset{Y,Z}\pi R))$
Consider the relation $R(X Y Z)$ has the following tuples XYZ123124321_________ tuples in the result of following relational algebra expression$(\underset{X,Y}...
Registered user 7
2.6k
views
Registered user 7
asked
Feb 5, 2016
Databases
databases
natural-join
+
–
1
votes
3
answers
50
Relation between Intersection and natural inner join on common column
When , then the cost of computing is (A) the same as R S (B) greater the R S (C) less than R S (D) cannot say anything
When , then the cost of computing is(A) the same as R S (B) greater the R S(C) less than R S (D) cannot say anything
Purple
1.7k
views
Purple
asked
Jan 24, 2016
Databases
natural-join
referential-integrity
databases
+
–
1
votes
2
answers
51
Left outer join
Given answer for this question is: Should last row be present in the result. Please check
Given answer for this question is:Should last row be present in the result. Please check
shikharV
551
views
shikharV
asked
Jan 13, 2016
Databases
databases
natural-join
+
–
1
votes
1
answer
52
Maximum and minimum size of the join of two relations
I am confused about this problem: Relation A -> m tuples Relation B -> n tuples What is the maximum and minimum size of natural join? According to this, maximum can be -> min(m,n) and minimum can be 0. I want to know if it is asked that what is maximum and minimum size on join operation (not natural join) will the answer get changed?
I am confused about this problem:Relation A - m tuplesRelation B - n tuplesWhat is the maximum and minimum size of natural join?According to this, maximum can be - min(m...
shikharV
8.5k
views
shikharV
asked
Dec 8, 2015
Databases
databases
natural-join
+
–
6
votes
5
answers
53
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...
learncp
5.2k
views
learncp
asked
Sep 5, 2015
Databases
databases
natural-join
+
–
0
votes
3
answers
54
if natural join is done then min and max no. of tuples if referential integrity is taken and not
R(ABC) S(BDE) F:A->B B ->C B->D D->E AND R HAS 100 TUPLES AND S HAS 200
R(ABC) S(BDE)F:A->B B ->C B->D D->EAND R HAS 100 TUPLES AND S HAS 200
uzumzki
1.9k
views
uzumzki
asked
Aug 17, 2015
Databases
natural-join
referential-integrity
+
–
31
votes
2
answers
55
GATE CSE 2015 Set 2 | Question: 32
Consider two relations $R_1(A,B)$ with the tuples $(1,5), (3,7)$ and $R_2(A,C) = (1,7),(4,9)$. Assume that $R(A,B,C)$ is the full natural outer join of $R_1$ and $R_2$. Consider the following tuples of the form $(A,B,C):$ ... contains all $a, b, c, d, e, f, g$. $R$ contains $e, f, g$ but not $a, b$. $R$ contains $e$ but not $f, g$.
Consider two relations $R_1(A,B)$ with the tuples $(1,5), (3,7)$ and $R_2(A,C) = (1,7),(4,9)$.Assume that $R(A,B,C)$ is the full natural outer join of $R_1$ and $R_2$. Co...
go_editor
8.9k
views
go_editor
asked
Feb 12, 2015
Databases
gatecse-2015-set2
databases
normal
natural-join
+
–
42
votes
4
answers
56
GATE IT 2006 | Question: 14
Consider the relations $r_{1}\text{(P, Q, R)}$ and $r_{2}\text{(R, S, T)}$ with primary keys $\text{P}$ and $\text{R}$ respectively. The relation $r_{1}$ contains $2000$ tuples and $r_{2}$ contains $2500$ tuples. The maximum size of the join $r_1⋈ r_2$ is : $2000$ $2500$ $4500$ $5000$
Consider the relations $r_{1}\text{(P, Q, R)}$ and $r_{2}\text{(R, S, T)}$ with primary keys $\text{P}$ and $\text{R}$ respectively. The relation $r_{1}$ contains $2000$ ...
Ishrat Jahan
17.1k
views
Ishrat Jahan
asked
Oct 31, 2014
Databases
gateit-2006
databases
joins
natural-join
normal
+
–
41
votes
8
answers
57
GATE CSE 2010 | Question: 43
The following functional dependencies hold for relations $R(A, B, C)$ and $S(B, D, E).$ $ B \to A$ $A \to C$ The relation $R$ contains $200$ tuples and the relation $S$ contains $100$ tuples. What is the maximum number of tuples possible in the natural join $R \bowtie S$? $100$ $200$ $300$ $2000$
The following functional dependencies hold for relations $R(A, B, C)$ and $S(B, D, E).$ $ B \to A$$A \to C$The relation $R$ contains $200$ tuples and the relation $S$ con...
go_editor
13.0k
views
go_editor
asked
Sep 30, 2014
Databases
gatecse-2010
databases
normal
natural-join
database-normalization
+
–
45
votes
5
answers
58
GATE CSE 2005 | Question: 30
Let r be a relation instance with schema R = (A, B, C, D). We define $r_1 = \pi_{A, B, C} (R)$ and $r_2=\pi_{A, D} (r)$. Let $s =r_1 \: * \: r_2$ where $*$ denotes natural join. Given that the decomposition of $r$ into $r_1$ and $r_2$ is lossy, which one of the following is TRUE? $s \subset r$ $r \cup s =r$ $r \subset s$ $r*s=s$
Let r be a relation instance with schema R = (A, B, C, D). We define $r_1 = \pi_{A, B, C} (R)$ and $r_2=\pi_{A, D} (r)$. Let $s =r_1 \: * \: r_2$ where $*$ denotes natura...
Kathleen
16.1k
views
Kathleen
asked
Sep 22, 2014
Databases
gatecse-2005
databases
relational-algebra
natural-join
normal
+
–
64
votes
7
answers
59
GATE CSE 2004 | Question: 14
Consider the following relation schema pertaining to a students database: Students (rollno, name, address) Enroll (rollno, courseno, coursename) where the primary keys are shown underlined. The number of tuples in the student and Enroll tables are $120$ and $8$ respectively. What ... Student * Enroll), where *' denotes natural join? $8, 8$ $120, 8$ $960, 8$ $960, 120$
Consider the following relation schema pertaining to a students database:Students (rollno, name, address)Enroll (rollno, courseno, coursename)where the primary keys are s...
Kathleen
28.4k
views
Kathleen
asked
Sep 18, 2014
Databases
gatecse-2004
databases
easy
joins
natural-join
+
–
Page:
« prev
1
2
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register