Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following relations Product (name, production-year, rating, company-name) Company (name, state, employee-num) Assume cach product is produced by just one company, whose name is

image text in transcribed
Consider the following relations Product (name, production-year, rating, company-name) Company (name, state, employee-num) Assume cach product is produced by just one company, whose name is mentioned in the company-name attribute of the Product relation. Attributes name are the primary key for both relations Product and Company. Attribute company-name is a foreign key from relation Product to relation Company. Attribute rating shows how popular a product is and its values are between 1-5. The following statistics are available about the relations Product B(Produt)1000 T(Product) 45000 V(Product, company-name)-300 V(Product, state)-50 Company B(Company) 25 T(Company)-500 The following query returns the products with rating of 5 that are produced after 2000 and the states of their companies SELECT p.name, c.state FROM Product p, Company WHERE p.company-name c.name and p.production-year 2000 and p.rating 5 Suggest an optimized query evaluation plan for the above query. Then, estimate the size of each intermediate relation in your query plan. By an intermediate relation, I mean the relation created after each selection or join

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

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

Students also viewed these Databases questions

Question

10. Why is it important to check cultural generalizations? (LO 7-7)

Answered: 1 week ago

Question

What aspects would it be impossible to capture?

Answered: 1 week ago

Question

Enhance your words with effective presentation aids

Answered: 1 week ago