Logical database design is the process of modifying the physical database design to improve performance.

Question

Quizplus · Accepted Answer

Logical database design is the process of defining the structure of the database in terms of relationships, constraints, and business rules, without considering how it will be implemented physically. Physical database design, on the other hand, is the process of mapping the logical design onto a specific DBMS, taking into account physical characteristics such as storage capacity, file structures, and access methods. While logical database design can impact performance indirectly, it is primarily concerned with ensuring data integrity and consistency. Performance optimization is typically handled through physical database design and tuning.

Logical Database Design Is the Process of Modifying the Physical