Consider the account relation as shown below. a. Construct a bitmap index on the attributes branch-name and

Question:

Consider the account relation as shown below.

a. Construct a bitmap index on the attributes branch-name and balance, dividing balance values into 4 ranges: below 250, 250 to below 500, 500 to below 750, and 750 and above.

b. Consider a query that requests all accounts in Downtown with a balance of 500 or more. Outline the steps in answering the query, and show the final and intermediate bitmaps constructed to answer thequery.