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 design for a database that will support the enterprise’s
operations and objectives for the required database system. It represents data and relationships
between data required by all major application areas and user groups.
Answer C 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 the resources 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 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.