$1)$ A$)$Create a bitmap index on faculty Rank

for Faculty Table

B$)$ Create a bitmap join index Faculty Rank for Offering Table

C$)$ Show the addressing steps and result in order to satisfy the following queries.

Select facID

From Offering

Where Rank $=$Professor$$ OR

Offering#$=3100$