Which of the following is the process of creating adesign for the database that will support the enterprise’s
operations and objectives for the required databasesystem?
A.
Identifying relationships between objects
B.
Application design
C.
Database planning
D.
Database design
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. 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 columnsto the
tables that establish a link from
one table to another.