Consider the following relation Cars: Brand Type Color Risk Suzuki Alto Silver Medium Suzuki Mehran.

/in /by

Consider the following relation Cars:
BrandType
ColorRiskSuzuki
AltoSilverMediumSuzukiMehranRedHighToyotaCrownBlackLowToyotaCorollaRedMediumHondaAccordSilverLowHondaCivicBlackLowBMWABlackLow
I. Construct a bitmap index for the attributes Brand and Color forthis table.
II. Indicate how these two bitmap-indices can be used to answer thequery:
“Givethe total number of red Toyota cars with a medium riskscore”.