Consider the "account" relation shown below:

$($a$)$ Construct a bitmap index on the attributes branchCity and balance, dividing balance values into $2$ ranges: below

$500,500$ and above.

$($b$)$ Consider a query that retrieves all accounts in Seoul with balance of $500$ or more. Outline the steps in answerin

the query, and show the final bitmap constructed to answer the query.