Construct a bitmap index for the attributes Brand and Color for this table
Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1490
Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1495
Construct a bitmap index for the attributes Brand and Color for this table
Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1490
Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1495
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”.
