Search results for sql+join / GATE Overflow for GATE CSE

0 votes

1 answer

1

Molina Exercise-6.2.2 page-267 SQL
Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Find those manufacturers of at least two different computers (PC's or laptops) with speeds of at least 3.0 is my query ... AND count(distinct model)>=2 UNION select maker from Product NATURAL JOIN Laptop where speed>=3 AND count(distinct model)>=2

Product(maker, model, type)PC(model, speed, ram, hd, price)Laptop(model, speed, ram, hd, screen, price)Find those manufacturers of at least two different computers (PC’...

aditi19

1.7k views

aditi19 asked May 7, 2019

0 votes

0 answers

2

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?

aditi19

814 views

aditi19 asked May 8, 2019

0 votes

0 answers

3

JOIN (Natural join)
In a natural join, the common attribute occur only once, but in join https://gateoverflow.in/3718/gate2004-it-74 Select * from Student, Department in this common, attribute we have given m+n I tried in w3 schools https://www.w3schools. ... Orders, Customers WHERE City='Berlin' AND OrderID = '10248' here common attribute is occuring only once, PLease guide .

In a natural join, the common attribute occur only once, but in joinhttps://gateoverflow.in/3718/gate2004-it-74Select * from Student, Departmentin this common, attribute ...

Learner_jai

422 views

Learner_jai asked Dec 14, 2018

0 votes

0 answers

4

Natural Join
Consider two relations R(A, B, C) and S(B, D) with R contains 5000 tuples stored in a sequential file sorted on attribute A and S contain 100000 tuples stored in a sequential file sorted on attribute B. Each block can hold 10 R tuples or 10 S tuples. Which one of the following index is most appropriate for answering query R (natural Join) S (Assume index always stored in memory)

Consider two relations R(A, B, C) and S(B, D) with R contains 5000 tuples stored in a sequential file sorted on attribute A and S contain 100000 tuples stored in a sequen...

Na462

772 views

Na462 asked Jul 14, 2018

0 votes

0 answers

5

Understanding theta join operation
Q.1. Does theta join operator requires following union compatibility requirements?: Same number of columns Domain of corresponding columns should be same I feel no, since I came across following fact: $\sigma_\theta( R_1\times R_2)=R_1⋈_\theta R_2$ ... as shown above, does it mean columns of resultant relation will contain ALL columns from both $R_1$ and $R_2$?

Q.1. Does theta join operator requires following union compatibility requirements?:Same number of columnsDomain of corresponding columns should be sameI feel no, since I ...

GateAspirant999

643 views

GateAspirant999 asked May 12, 2018

1 votes

1 answer

6

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

learner_geek

1.3k views

learner_geek asked Jan 24, 2018

2 votes

1 answer

7

#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!

iarnav

1.4k views

iarnav asked Nov 27, 2017

0 votes

0 answers

8

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

594 views

kauray asked Apr 20, 2017

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true