Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following query involves three relations: R(a, b) S(p, q) W(x, y) We have the following statistics about the three tables: T(R) = 2000 V(R,

The following query involves three relations:

R(a, b) S(p, q) W(x, y)

We have the following statistics about the three tables:

T(R) = 2000 V(R, a) = 50 V(R, b)=20

T(S) = 4000 V(S, p) = 400 V(S, q) = 100

T(W) = 1000 V(W, x) = 200 V(W, y) = 100

Now consider the following query plan:

1)U1 = (S join W) on S.q = W.x

2)U2 = (R join U1 ) on R.b = U1.y

3)U3 = Select a = 42 (U2)

4)U4 = Project {b,q} (U3)

What are the estimated statistics (T() and V()) of the result of each relational operation given above

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago