Which of the following is the process of creating a design for the database that will support the
enterprise’s operations and objectives for the required database system?

A.
Identifying relationships between objects

B.
Application design

C.
Database planning

D.
Database design

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 B 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 A is incorrect. Identifying relationships between objects is the last step in database
planning, which is the ability to relate
information about various items in the database. Isolated types of information can be stored
separately, but the data can be combined
according to the requirements of the database engine. Identifying the relationship between objects
in the design process necessitates
looking at the tables, determining how the tables are logically related, and adding relational columns
to the tables that establish a link from
one table to another.