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 questionsDomain Data Modeling & Design
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.
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.
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.
Keep practicing
Take the free DMF-1220 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DMF-1220 practice questions
- Question 1The most important reason to implement operational data quality measurements is to inform…
- Question 2A goal of data governance is to enable an organisation to manage its data as a liability.
- Question 3SBA is an abbreviation for service-based architecture.
- Question 5The need to manage data movement efficiently is a primary driver for Data Integration and…
- Question 6A roadmap for enterprise data architecture describes the architecture’s 3 to 5-year devel…
- Question 7Architecture is the fundamental organization of a system, embodied in its components, the…
