DEA-C01 · Question #52
In data modeling, an entity-relationship diagram (ERD) is primarily used to:
The correct answer is B. Illustrate relationships between entities. An entity-relationship diagram (ERD) is primarily used in data modeling to visually represent and illustrate the relationships between different entities within a database or information system.
Question
In data modeling, an entity-relationship diagram (ERD) is primarily used to:
Options
- ATransform raw data into structured data.
- BIllustrate relationships between entities.
- CStore data in a physical location.
- DCleanse dirty data.
How the community answered
(21 responses)- B90% (19)
- C5% (1)
- D5% (1)
Why each option
An entity-relationship diagram (ERD) is primarily used in data modeling to visually represent and illustrate the relationships between different entities within a database or information system.
Transforming raw data into structured data is part of the ETL process, not the primary function of an ERD, which is a design tool.
An Entity-Relationship Diagram (ERD) is a conceptual data model that uses a graphic notation to show the relationships among data entities (e.g., tables or objects) in a system. Its main purpose is to design and communicate how different pieces of information relate to each other.
Storing data in a physical location refers to the implementation aspect of a database, whereas an ERD is a logical design tool.
Cleansing dirty data is a data quality management task, separate from the primary purpose of an ERD, which is to model data structures and relationships.
Concept tested: Data modeling fundamentals - ERD purpose
Topics
Community Discussion
No community discussion yet for this question.