________ database design is driven not only from the previously developed E-R data model for the application or enterprise but also from form and report layouts.
A)Logical
B)Physical
C)Normalized
D)De-normalized

Question

Quizplus · Accepted Answer

Logical database design is based on the previously developed E-R data model, and it determines the relational schema, data dependencies, and constraints. It is independent of any specific DBMS and is not influenced by the physical implementation considerations such as hardware, software, and storage management. In contrast, physical design is influenced by implementation considerations and determines how the logical design is implemented in a specific DBMS. Form and report layouts are part of the user interface design and do not affect the logical or physical database design. Nor do they provide information about data dependencies, relationships, and constraints that are necessary for building a robust and efficient database system.

________ Database Design Is Driven Not Only from the Previously