DMF-1220 practice question 4 of 35

For each subject area logical model: Decrease detail by adding attributes and less-significant entities and relationships.

Full set: 724 questions

Domain Data Modeling & Design

Answer options
A: TRUE
B: FALSE
Correct Answer:
FALSE
Explanation

The statement is incorrect. The process of adding attributes, less-significant entities, and relationships to a logical model serves to increase its level of detail, granularity, and specificity. This refinement is a standard progression when moving from a high-level conceptual model to a more detailed logical model. Decreasing detail involves the opposite actions, such as abstraction, generalization, or removing granular elements to create a higher-level, less complex view.

Why Incorrect

This is a True/False question. The statement is false because it incorrectly correlates the action of adding model components (attributes, entities) with the outcome of decreasing detail. In standard data modeling practice, adding these elements is the primary method for increasing a model's detail to fully represent business requirements.

References

1. DAMA International. (2017). DAMA-DMBOK: Data Management Body of Knowledge (2nd ed.).

Section: Chapter 6

Section 3.3

"Data Model Types

" Figure 17.

Content: This section explicitly describes the progression from a Conceptual Data Model (CDM) to a Logical Data Model (LDM) as a process of adding detail. The LDM "adds more detail to the conceptual model elements" and "includes all attributes and relationships among entities." This directly contradicts the question's assertion that adding these elements decreases detail.

2. Silberschatz

A.

Korth

H. F.

& Sudarshan

S. (2019). Database System Concepts (7th ed.). McGraw-Hill.

Section: Chapter 7

"Database Design and the E-R Model."

Content: This foundational academic text explains that the database design process moves from a high-level conceptual schema (e.g.

an E-R diagram with just entities and relationships) to a more detailed logical schema. This refinement involves specifying attributes for each entity

defining primary keys

and detailing all relationships. This process is consistently presented as one of increasing

not decreasing

detail.

3. Ullman

J. D.

& Widom

J. (2008). A First Course in Database Systems (3rd ed.). Pearson.

Section: Chapter 4

"The Database Design Process."

Content: This university-level textbook describes the design process as starting with a high-level specification (conceptual design) and progressively adding constraints and details to create a logical schema. The text states

"The E/R model is a high-level design model... The relational model is a 'logical' or 'implementation' model." The transition between these stages inherently involves adding details like attributes and precise relationship definitions.

Scroll to Top