Consider the instructor relation shown in Figure 14.1.

a. Construct a bitmap index on the attribute salary, dividing salary values into four ranges: below 50,000, 50,000 to below 60,000, 60,000 to below 70,000, and 70,000 and above.

b. Consider a query that requests all instructors in the Finance department with a salary of 80,000 or more. Outline the steps in answering the query, and show the final and intermediate bitmaps constructed to answer the query.

Figure 14.1

Transcribed Image Text:

Brandt Califieri Crick Einstein El Said El Said Mozart Gold Katz Kim Mozart Singh Srinivasan Wu