Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you have a roster from a census return with N entries in alphabetical order by first name. Each page has P entries. 1. What

image text in transcribed

Suppose you have a roster from a census return with N entries in alphabetical order by first name. Each page has P entries. 1. What is the lower bound Bi and the upper bound Bu on the number of pages that must be examined to find a given first name using a binary search? Assume that having computed a page number, you can open directly to that page. Use N and P as your variables 2. Now suppose a 1-page table of contents is added to the roster. It lists the first "first name" on each of the other pages (Assume no first name has more than 1 page of entries). How many pages that must be examined to look up a given first name? 3. Now suppose that the roster is reorganized such that each page contains a list of names with the same initials. For example, 'Thomas Jam Andrew' falls on the same page as 'Travis Jam Anand' (both have initials 'TJA'). Assume that no pattern takes more than one page, and there are a total of M pages. Finally, assume that given the pattern you can go directly to the page. How many pages must be checked to find a particular name? 4. Using the same organization as question 3, assuming a page still has room for up to P entries, what is the occupancy percentage of an average page in the new roster? 5. Now suppose we add a two-level index to the roster. The one-page primary index lists the first name on each of the secondary index pages. The secondary index pages list the first name on each of the roster pages. Assume no first name has more than 1 page of entries. How many pages must be examined to look up a given first name

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

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

More Books

Students also viewed these Databases questions