You work as a Database Administrator for InfoTech Inc. The company has a database and they want you to
create a design for a database that will support the enterprise’s operations and objectives. Which of the
following will you use to accomplish the task?
A.
Application design
B.
Database design
C.
Database planning
D.
Requirements collection and analysis
Explanation:
Database design is the process of creating a designfor a database that will support the enterprise’s operations
and objectives for the required database system. Itrepresents data and relationships between data required by
all major application areas and user groups. AnswerC is incorrect. 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 A is incorrect. Application design is a design of the user interface and the application programs that
use and process the database. Database and application design are parallel activities. Application design
includes two important activities: transaction design and user interface design. Answer D is incorrect.
Requirements collection and analysis is the processof 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.