The goal of logical database design is ____.
A) to fine tune the database's physical database design
B) to convert databases from a hierarchical or network structure to a relational structure
C) to improve performance
D) to create well-structured tables that properly reflect the company's business environment
E) None of the above.

Question

Quizplus · Accepted Answer

The goal of logical database design is to create well-structured tables that properly reflect the company's business environment. This includes identifying relationships between data elements and organizing them into tables that minimize data redundancy and improve data integrity. Logical design is an important step before moving on to physical database design, which involves fine-tuning the database for performance and storage considerations. Conversion from hierarchical or network structures to relational structures is one example of a logical design effort. However, improving performance is not the primary goal of logical design.

The Goal of Logical Database Design Is ____