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 theresources 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 identificationprocess 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.