For these questions, there exists 4 relations: R(A, B,C), S(C,D), T(D,E,F), and U(B,G). The size of attributes A to D are 10 bytes each, attributes E and F have size 100 bytes, and attribute G has...


For these questions, there exists 4 relations: R(A, B,C), S(C,D), T(D,E,F), and U(B,G).<br>The size of attributes A to D are 10 bytes each, attributes E and F have size 100 bytes, and<br>attribute G has size 1000 bytes. The blocks size is 16,384 bytes with no spanning.<br>Relation R has 100,000 tuples, relation S has 20,000 typles, T has 5,000 tuples, and relation U has<br>150,000 tuples.<br>Other statistics: V(R,C)=10,000, V(S,D)=500, V(R,B)=1000.<br>Assume that attributes with the same name can be joined across relations (and duplicates are<br>eliminated during a join), and the fırst attribute is the primary key of the relation.<br>Answer the following questions about calculating intermediate result sizes. Answer the question in<br>terms of the # of tuples and the # of blocks.<br>Question 3<br>What is the size of op=10(S)?<br>Tuples:<br>Blocks:<br>Question 4<br>What is the size of oc>10(S)?<br>Tuples:<br>Blocks:<br>Question 5<br>What is the size of og=5(R)?<br>Tuples:<br>Blocks:<br>

Extracted text: For these questions, there exists 4 relations: R(A, B,C), S(C,D), T(D,E,F), and U(B,G). The size of attributes A to D are 10 bytes each, attributes E and F have size 100 bytes, and attribute G has size 1000 bytes. The blocks size is 16,384 bytes with no spanning. Relation R has 100,000 tuples, relation S has 20,000 typles, T has 5,000 tuples, and relation U has 150,000 tuples. Other statistics: V(R,C)=10,000, V(S,D)=500, V(R,B)=1000. Assume that attributes with the same name can be joined across relations (and duplicates are eliminated during a join), and the fırst attribute is the primary key of the relation. Answer the following questions about calculating intermediate result sizes. Answer the question in terms of the # of tuples and the # of blocks. Question 3 What is the size of op=10(S)? Tuples: Blocks: Question 4 What is the size of oc>10(S)? Tuples: Blocks: Question 5 What is the size of og=5(R)? Tuples: Blocks:

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here