1|Page
WGU C792 Task 2: Entity Relationship Diagram (ERD) Reflection
2026-2027 BANK QUESTIONS WITH DETAILED VERIFIED
ANSWERS EXAM QUESTIONS WILL COME FROM HERE
(100% CORRECT ANSWERS A+ GRADED
1. What is the primary purpose of an Entity Relationship Diagram?
A. To display the physical storage allocation of data files
B. To visually represent the logical structure of a database
C. To calculate the normalized form of a relational schema
D. To replace the need for a data dictionary
Answer: B
Explanation: An ERD provides a high-level visual representation of the
entities within a system, their attributes, and the relationships between
them, serving as a blueprint for the logical database design.
2. In an ERD, what does an entity represent?
A. A link between two attributes
B. A specific instance of a relationship
C. A real-world object or concept about which data is stored
D. A foreign key constraint
Answer: C
,2|Page
Explanation: An entity represents a distinguishable object, person,
place, concept, or event in the domain of interest that can be uniquely
identified and about which data can be collected.
3. Which of the following is the weakest form of relationship
cardinality?
A. One-to-one
B. One-to-many
C. Many-to-many
D. Recursive
Answer: C
Explanation: Many-to-many relationships are considered complex and
must be decomposed into two one-to-many relationships using an
associative entity, making them structurally weak in direct
implementation.
4. How is an associative entity primarily identified in an ERD?
A. It has no attributes
B. It contains a composite primary key derived from the entities it links
C. It is always a weak entity
D. It does not participate in any relationships
Answer: B
,3|Page
Explanation: An associative entity resolves a many-to-many relationship
and inherits the primary keys of the related entities to form its own
composite primary key, often with additional descriptive attributes.
5. What does cardinality specify in an ERD?
A. The data type of each attribute
B. The number of attributes in an entity
C. The minimum and maximum number of relationship instances an
entity can participate in
D. The hierarchical level of an entity in the schema
Answer: C
Explanation: Cardinality defines the quantitative constraints of a
relationship, indicating the range of occurrences (e.g., zero, one, or
many) an entity instance can have relative to another entity.
6. Which symbol is conventionally used to represent an entity in a
Crow's Foot ERD?
A. A diamond
B. An oval
C. A rectangle divided into two sections
D. A circle
Answer: C
, 4|Page
Explanation: In Crow's Foot notation, entities are depicted as
rectangles, often divided horizontally to separate the entity name from
its attributes.
7. What is the role of a primary key in an entity?
A. To encrypt sensitive attribute data
B. To uniquely identify each instance of the entity
C. To link the entity directly to the physical storage
D. To describe non-unique characteristics
Answer: B
Explanation: The primary key is a selected candidate key that ensures
entity integrity by guaranteeing each row or instance within the entity
is unique and not null.
8. An attribute that can be derived from other existing attributes is
known as what?
A. A composite attribute
B. A multi-valued attribute
C. A derived attribute
D. A key attribute
Answer: C
Explanation: Derived attributes are not stored directly but are
calculated or inferred from other attributes, such as calculating age
from a date of birth.
WGU C792 Task 2: Entity Relationship Diagram (ERD) Reflection
2026-2027 BANK QUESTIONS WITH DETAILED VERIFIED
ANSWERS EXAM QUESTIONS WILL COME FROM HERE
(100% CORRECT ANSWERS A+ GRADED
1. What is the primary purpose of an Entity Relationship Diagram?
A. To display the physical storage allocation of data files
B. To visually represent the logical structure of a database
C. To calculate the normalized form of a relational schema
D. To replace the need for a data dictionary
Answer: B
Explanation: An ERD provides a high-level visual representation of the
entities within a system, their attributes, and the relationships between
them, serving as a blueprint for the logical database design.
2. In an ERD, what does an entity represent?
A. A link between two attributes
B. A specific instance of a relationship
C. A real-world object or concept about which data is stored
D. A foreign key constraint
Answer: C
,2|Page
Explanation: An entity represents a distinguishable object, person,
place, concept, or event in the domain of interest that can be uniquely
identified and about which data can be collected.
3. Which of the following is the weakest form of relationship
cardinality?
A. One-to-one
B. One-to-many
C. Many-to-many
D. Recursive
Answer: C
Explanation: Many-to-many relationships are considered complex and
must be decomposed into two one-to-many relationships using an
associative entity, making them structurally weak in direct
implementation.
4. How is an associative entity primarily identified in an ERD?
A. It has no attributes
B. It contains a composite primary key derived from the entities it links
C. It is always a weak entity
D. It does not participate in any relationships
Answer: B
,3|Page
Explanation: An associative entity resolves a many-to-many relationship
and inherits the primary keys of the related entities to form its own
composite primary key, often with additional descriptive attributes.
5. What does cardinality specify in an ERD?
A. The data type of each attribute
B. The number of attributes in an entity
C. The minimum and maximum number of relationship instances an
entity can participate in
D. The hierarchical level of an entity in the schema
Answer: C
Explanation: Cardinality defines the quantitative constraints of a
relationship, indicating the range of occurrences (e.g., zero, one, or
many) an entity instance can have relative to another entity.
6. Which symbol is conventionally used to represent an entity in a
Crow's Foot ERD?
A. A diamond
B. An oval
C. A rectangle divided into two sections
D. A circle
Answer: C
, 4|Page
Explanation: In Crow's Foot notation, entities are depicted as
rectangles, often divided horizontally to separate the entity name from
its attributes.
7. What is the role of a primary key in an entity?
A. To encrypt sensitive attribute data
B. To uniquely identify each instance of the entity
C. To link the entity directly to the physical storage
D. To describe non-unique characteristics
Answer: B
Explanation: The primary key is a selected candidate key that ensures
entity integrity by guaranteeing each row or instance within the entity
is unique and not null.
8. An attribute that can be derived from other existing attributes is
known as what?
A. A composite attribute
B. A multi-valued attribute
C. A derived attribute
D. A key attribute
Answer: C
Explanation: Derived attributes are not stored directly but are
calculated or inferred from other attributes, such as calculating age
from a date of birth.
