Which of the following is NOT a key step in logical database design?
A) Combine normalized data requirements from all user interfaces into one consolidated logical database model.
B) Compare the consolidated logical database design with the translated E-R model and produce, through view integration, one final logical database design for the application.
C) Model how data flow through an information system, the relationships among the data flows, and how data come to be stored at specific locations.
D) Translate the conceptual E-R data model for the application into normalized data requirements.
E) Using normalization principles, develop a logical data model for each known user view for the application.

Question

Quizplus · Accepted Answer

Modeling how data flows through an information system and how it is stored at specific locations is not a key step in logical database design. It is a step in physical database design. The key steps in logical database design include translating the conceptual E-R data model, developing a logical data model for each user view, consolidating the models into one final design, and integrating views.

Which of the Following Is NOT a Key Step in Logical