Which of the following is undertaken at any time prior to the logical design, provided that sufficient
information is available regarding system requirements?

A.
Application design

B.
Prototyping

C.
DBMS selection

D.
Database planning

Explanation:
The process involves selection of an appropriate DBMS to support the database system undertaken
at any time prior to the logical design,
provided sufficient information is available regarding system requirements. There are few steps for
selecting a DBMS and they are as follows:
Define terms of reference of study
Shortlist two or three products
Evaluate the product
Recommend selection and produce reports
Answer B is incorrect. Prototyping refers to the creation of a working model of the database system.
The purpose of Prototyping is to
suggest improvements or even add new features; to identify features of a system that work well, or
are inadequate; to evaluate feasibility of
a particular system design; to clarify a user’s requirements.
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. 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.