Home /
Expert Answers /
Computer Science /
consider-two-relations-r-a-b-and-s-a-c-field-a-is-the-primary-key-of-relation-s-and-the-forei-pa164

Consider two relations R(A, B) and S(A, C). Field A is the primary key of relation S, and the foreign key of relation R referencing S. Assume that page-oriented nested-loop join is used for R * S (natural join). Let R be the outer relation, and S be the inner relation. Given the following tuples of R and S, what are the first 4 tuples produced by R * S? Assume each block can store only 3 R tuples or S tuples. [8 marks]