Which model best describes the Logical model?

• A. Physical model
• B. Logical model
• C. Conceptual model
• D. Data Analysis

Answer: (B)

The main idea being tested is understanding the different levels of data modeling. A logical model focuses on the organization of data in a way that shows entities, their attributes, keys, and the relationships between entities, along with constraints like referential integrity. It describes how data is logically structured and related, independent of how it will be stored or which database system will be used.

Other levels describe storage details or business concepts at a higher level: a conceptual model maps out major entities and relationships without technical details, a physical model specifies how data is stored on hardware (tables, columns, data types, indexes, storage), and data analysis is about examining data to derive insights rather than modeling. So the logical model is the best fit for describing the logical structure of data.