446 views
1 votes
1 votes
Consider two table R and S. Now suppose if we join the two tables using Natural Join (or any other Join for that matter), is it mandatory for the attributes (common attribute between R and S) must have the same range of values? (It's not mentioned that if it's dependent by a foreign key)

1 Answer

Related questions

3 votes
3 votes
3 answers
1
Pankaj Joshi asked Feb 1, 2017
2,228 views
Consider the following relation:R (A B C) A primary key with 100 tuples.S (E F G) E primary key with 50 tuples.T (AE D) AE primary key with 80 tuples.U (D G H) H primary ...
1 votes
1 votes
3 answers
3
0 votes
0 votes
0 answers
4
kd..... asked Apr 30, 2019
659 views
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not workingThe queries are The output are