Peter works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server
database. Peter has to construct an Entity-Relationship schema design for the data he will use in the
database. Which of the following database designs will he use to accomplish the task?

A.
Physical database design

B.
Conceptual database design

C.
Logical database design

D.
Application design

Explanation:
Conceptual database design is the process of constructing a model for the data at a high level of
abstraction without using DBMS. It consists
of the construction of an Entity-Relationship schema, providing an optimal description of the user
requirements.

Answer D 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. Physical database design is the process of producing a description of the
database implementation on secondary
storage. It describes base relations, file organizations, and indexes used to achieve efficient access to
data. It also describes any associated
integrity constraints and security measures, tailored to a specific DBMS system. This involves the
actual programming of the database, taking
into account the features and limitations of the DBMS and the client.
Answer C is incorrect. Logical database design is the process of creating a data model of an
enterprise based on a specific data model,
but independent of a particular DBMS. In the logical database design stage, users can define tables
and relationships that reflect the
conceptual design.