is it reqire primary key and foreign key relation ship to join relational datab

is it reqire primary key and foreign key relation ship to
join relational databases?if yes? explain?

Question Posted / guest

3 Answers
8055 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / mike

If you are performing the join using a SOURCE QUALIFIER ,
the relational sources should have a primary and foreign
key relationship.
If you are performing the join using a JOINER, no need to
have a primary and foreign key relationship.

Is This Answer Correct ?

10 Yes

5 No

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / usha

we want join in SQ we should have primary key and foreign
key relation ship ...

but, in joiner we dont need primary key and foreign key
relation ship

Is This Answer Correct ?

0 Yes

0 No

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain..

Answer / bharu_295

if u want to join the tables we need to have primary and foreign key relationship other wise if we join we get Cartesian product of the data.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer