Construct a bitmap index for the attributes Brand and Color for this table
Problems
Q 1. Consider the following relation Cars:
| Brand | Type | Color | Risk |
| Suzuki | Alto | Silver | Medium |
| Suzuki | Mehran | Red | High |
| Toyota | Crown | Black | Low |
| Toyota | Corolla | Red | Medium |
| Honda | Accord | Silver | Low |
| Honda | Civic | Black | Low |
| BMW | A | Black | Low |
I. Construct a bitmap index for the attributes Brand and Color for this table.
II. Indicate how these two bitmap-indices can be used to answer the query:
“Give the total number of red Toyota cars with a medium risk score”.