Database Fundamentals — Question 140

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?

Answer options

• A. Logical database design
• B. Conceptual database design
• C. Physical database design
• D. Application design

Correct answer: A

Explanation

The correct answer is A, Logical database design, as it focuses on the structure of the data independent of any specific database management system. Option B, Conceptual database design, is more about high-level data organization, while Option C, Physical database design, deals with the implementation details specific to a DBMS, and Option D, Application design, pertains to the software that interacts with the database rather than the database structure itself.