Which of the following is a management activity that allows the stages of the database application
to be realized as efficiently and effectively as possible?
A.
Database planning
B.
Identifying information for objects
C.
Object identification
D.
Requirements collection and analysis
Explanation:
Database planning is a management activity that allows the stages of the database application to be
realized as efficiently and effectively as
possible. It identifies the work to be done and the resources with which to do it. Database planning
is integrated with the overall IS strategy
of the organization.
Answer B is incorrect. Identifying information for objects is the fourth step in database planning
where the information for each object
is stored. In a table, there are four columns that contain different types of information for objects:
1.Categorical column: In this column, data is classified and grouped, and a limited selection of data is
stored.
2.Relational or referential column: In this column, a link is established between information in one
table and related information in
another table.
3.Identifier column: In this column, each item stored in the table is identified.
4.Raw data column: In this column, tangible information is stored and is determined by a source that
is external to the database.
Answer D is incorrect. Requirements collection and analysis is the process of collecting and
analyzing information about the part of the
organization that is to be supported by the database application, and using this information to
identify the user’s requirements of the new
system.
Answer C is incorrect. In the object identification process in database planning, it is necessary to
identify the key objects or entities for
database management. There are generally a few primary objects, and once these are identified, the
related items become visible.