We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.

# Databases - Natural Joins

# Databases - Natural Joins

Matthew_W_Noble + 0 comments The answer is:

50 1 6

A natural join is effectively combining two columns using the common data that they have.

In the question, we have:

**R(A:C)**A : C 3,3 16,4 12,3 3,15 27,1

and

**S(B, C, D)**B : C : D 50,1,6 1,55,8 4,3,9

We are told that the first number is 27 from

**A**, therefore**B**,**C**, and**D**(or**X**,**Y**, and**Z**) are going to be the rows which correspond to that 27 in**A**. From**R(A, C)**this gives us a**C**of 1. And using**S(B, C, D)**, a**C**of 1 gives us a**B**of 50 and a**D**of 6. Therefore the answer is:(

**A**,**B**,**C**,**D**) = (27, 50, 1, 6).Regarding the input format, it needs to be entered as above on separate lines!

kevints + 0 comments I just really don't know..

krsticsmederevac + 0 comments A =27

A,C = 27,1

B,C,D = 50,1,6

50 1 6

irfanrahman72191 + 0 comments answer will be 50 1 6 note:all are in new line

justice_theledi + 0 comments sample solution

50

1

6

No more comments

Sort 5 Discussions, By:

Please Login in order to post a comment