Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider an Employee table with 100,000 rows, t(Emp)=100,000. 10 employee records fit per disk page, P(Emp)=10,000. There is a non-clustered hash index on the SS#

Consider an Employee table with 100,000 rows, t(Emp)=100,000. 10 employee records fit per disk page, P(Emp)=10,000. There is a non-clustered hash index on the SS# of the Emp table with a loading factor of 80%. This index structure consists of 100 buckets with no overflow chains. SS# is the primary key and its values are unique, v(SS#, Emp) = 100,000.

9. (10 points) How many I/Os are required to fetch those employees whose salary is 100K? Explain your answer.

10. (10 points) How many I/Os are required to fetch the employee whose SS# equals 232-56-7878? Explain your answer.

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

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago