You work as a Database Designer for DataOneWorld Inc. The company has a SQL Server database.
You are assigned the task of creating a data model of an enterprise based on a specific data model.
The model to be created should be independent of a particular DBMS. Which of the following
database designs will help you accomplish the task?
A.
Logical database design
B.
Conceptual database design
C.
Physical database design
D.
Application design
Explanation:
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.
Answer C 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 B is incorrect. 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 EntityRelationship 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.