Visit an organization that has implemented a database approach. Evaluate each of the following:

a. The organizational placement of data administration, database administration, and data warehouse administration.

b. The assignment of responsibilities for each of the functions listed in part a.

c. The background and experience of the person chosen as head of data administration.

d. The status and usage of an information repository (passive, active-in-design, active-in-production).

e. Accommodating growth

f. Security from unauthorized use

Secondary key indexes are important for supporting many reporting requirements and for providing rapid ad hoc data retrieval. Indexed sequential in comparison to indexed nonsequential allows more efficient use of space and faster sequential data processing without much, if any, sacrifice in random data record accessing speed. A bitmap is ideal for attributes that have even a few possible values, which is not true for conventional tree indexes. Indexes may be deleted because of storage space constraints or to reduce maintenance overhead.