A number of situations have been listed below. For each one, identify

A number of situations have been listed below. For each one, identify the need, if any, to create an index. Justify your answer. If there is indeed a need, suggest a way for the index to be created.

a. Banking applications that involve frequent retrieval of the “Account Balance” of customer accounts, where the column “Account Balance” appears in the “Account” table.

b. Applications involving frequent access to the records of “Contact Number,” which is a column appearing in the “Customer” Table, whose monthly “Instalment-Status” is pending and the column “Instalment Status” appears in “Instalment” table.

c. Daily report generation listing the Sales Depot of a retail chain, displaying the daily sales generated, ordered by the sales, starting with the depot generating maximum sales for the day.

d. An attribute “Sales Region” in the “Salesman” table, which can take 25 different values.

e. A field in a table that has long values.