Question

________ 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

Answer 1

Physical database design involves determining how data will be stored, influenced by an Entity-Relationship data model and the layout of forms and reports, to ensure efficient data management and retrieval.

Step-by-step explanation:

The database design described in the question is physical database design. This phase of database design is concerned with how data will be stored in the database, taking into account factors like storage devices, hardware performance, and the data processing needs of the enterprise. The physical design is indeed driven by an existing Entity-Relationship (E-R) data model, as well as by the layout of forms and reports that will be used to interact with the data. All these factors contribute to decisions about the storage structures and access strategies that will be used to ensure efficient data retrieval and management.