Which of the following is a purpose of logical and physical database design?
A) Structure the data in stable structures that are not likely to change over time and that have minimal redundancy.
B) Develop a logical database design that reflects the actual data requirements that exist in the forms and reports of an information system.
C) Develop a logical database design from which we can do physical database design.
D) Translate a relational database model into a technical file and database design.
E) All of the above.

Question

Quizplus · Accepted Answer

All of the options listed are purposes of logical and physical database design. The purpose of logical database design is to develop a logical database model or schema that is free from redundancies, anomalies, and inconsistencies. The purpose of physical database design is to create the technical blueprint for storing and retrieving the data in a database, based on the logical database design. In addition to these, logical and physical database design can help ensure that the data is structured in a way that reflects the actual data requirements, and that the database model can be translated into a technical database schema. Therefore, option E is the best choice as it encompasses all the options given.

Which of the Following Is a Purpose of Logical and Physical