Certificate in Business Data Analytics (CBDA) — Question 39

A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?

Answer options

• A. An abstraction of the conceptual data model that includes rules of normalization
• B. The layer of views created to summarize data or provide another perspective of certain data
• C. Modelling that involves objects being defined at the schema level
• D. A model that depicts the actual design of the relational database

Correct answer: A

Explanation

The correct answer, A, describes a logical database model as an abstraction that incorporates normalization rules, which is essential for structuring data logically. Option B refers to views, which are not part of the logical model. Option C relates to schema-level definitions, while option D describes the physical design of a database rather than the logical model.