Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following relational schema for this homework: Sailors ( sid: integer, sname: string, rating: integer, age: real ) Boats ( bid: integer, bname: string,

Use the following relational schema for this homework: Sailors(sid: integer, sname: string, rating: integer, age: real) Boats(bid: integer, bname: string, color: string) Reserves(sid: integer, bid: integer, day: date) Reserves : 100,000 tuples stored in 1,000 pages. There are 100 boats. Each boat is equally poplar (i.e., each has the same number of reservations). Sailors (S): Stored in 500 pages. There are 10 distinct rating levels (1 to 10), each with the same number of sailors. 1. The sid column takes up 20% of the data size of the Reserves relation. The sid and sname columns take up 70% of the data size of the Sailor relation. a. If you are given 3 memory pages, describe an efficient execution plan for the execution tree in the right. b. Estimate the processing time (I/O cost) of your computation stratgegy. You do not have to include the cost of writing the query result in your analysis. 2. If you have 4 memory pages, explain a better computation strategy to take advantage of the one extra memory page for the execution tree in the right. Estimate the processing time (I/O cost). You do not have to include the cost of writing the query result in your analysis.

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_2

Step: 3

blur-text-image_3

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

Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases

Authors: Joachim Schnier

1st Edition

0240809173, 978-0240809175

Students also viewed these Databases questions

Question

2. Do the same for your favorite female film character.

Answered: 1 week ago

Question

outline some of the current issues facing HR managers

Answered: 1 week ago