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 thelogical 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 describesany
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 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.