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

Which of the following is undertaken at any time prior to the logical design, provided that sufficientinformation
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.