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 accessto 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.