WGU C170 ER-Modeling Knowledge test
Exam Toolkit Questions and Verified Marking
Scheme 2024/2025
In Chen notation, there is no way to represent cardinality. - correct answer FALSE
Knowing the minimum and maximum number of .......................occurrences is very
helpful at the application software level. - correct answer entity
Connectivities and cardinalities are established by concise statements known as
business rules. - correct answer TRUE
A composite identifier is a primary key composed of more than one attribute. - correct
answer TRUE
An entity in the entity relationship model corresponds to a table in the relational
environment. - correct answer TRUE
In the Chen and Crow's Foot notations, an entity is represented with a rectangle
containing the entity's name. - correct answer TRUE
In implementation terms, an entity is existence-dependent if it has a mandatory primary
key. - correct answer FALSE
.......................___ expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity. - correct answer Cardinality
The _______ notation of entity-relationship modelling can be used for both conceptual
and implementation modelling. - correct answer UML
, A derived attribute is indicated in the Chen notation by a ......................._ that connects
the attribute and an entity. - correct answer dashed line
The concept of relationship strength is based on how the ......................._ of a related
entity is defined. - correct answer primary key
A weak relationship exists if the primary key of the related entity contains at least one
primary key component of the parent entity. - correct answer FALSE
To simplify the conceptual design, higher-order relationships are decomposed into
appropriate equivalent __________ relationships whenever possible. - correct answer
binary
When indicating cardinality, the first value represents the _.......................number of
associated entities. - correct answer minimum
Relationships between entities always operate in one direction. - correct answer
FALSE
The conceptual model can handle ______ relationships and multivalued attributes. -
correct answer M:N
Referential integrity and participation are both bidirectional, meaning that they must be
addressed in both directions along a relationship. - correct answer FALSE
A(n) _________ relationship is also known as an identifying relationship. - correct
answer strong
The Crow's foot symbol with two vertical parallel lines indicates ______ cardinality. -
correct answer (1,1)
Exam Toolkit Questions and Verified Marking
Scheme 2024/2025
In Chen notation, there is no way to represent cardinality. - correct answer FALSE
Knowing the minimum and maximum number of .......................occurrences is very
helpful at the application software level. - correct answer entity
Connectivities and cardinalities are established by concise statements known as
business rules. - correct answer TRUE
A composite identifier is a primary key composed of more than one attribute. - correct
answer TRUE
An entity in the entity relationship model corresponds to a table in the relational
environment. - correct answer TRUE
In the Chen and Crow's Foot notations, an entity is represented with a rectangle
containing the entity's name. - correct answer TRUE
In implementation terms, an entity is existence-dependent if it has a mandatory primary
key. - correct answer FALSE
.......................___ expresses the minimum and maximum number of entity occurrences
associated with one occurrence of the related entity. - correct answer Cardinality
The _______ notation of entity-relationship modelling can be used for both conceptual
and implementation modelling. - correct answer UML
, A derived attribute is indicated in the Chen notation by a ......................._ that connects
the attribute and an entity. - correct answer dashed line
The concept of relationship strength is based on how the ......................._ of a related
entity is defined. - correct answer primary key
A weak relationship exists if the primary key of the related entity contains at least one
primary key component of the parent entity. - correct answer FALSE
To simplify the conceptual design, higher-order relationships are decomposed into
appropriate equivalent __________ relationships whenever possible. - correct answer
binary
When indicating cardinality, the first value represents the _.......................number of
associated entities. - correct answer minimum
Relationships between entities always operate in one direction. - correct answer
FALSE
The conceptual model can handle ______ relationships and multivalued attributes. -
correct answer M:N
Referential integrity and participation are both bidirectional, meaning that they must be
addressed in both directions along a relationship. - correct answer FALSE
A(n) _________ relationship is also known as an identifying relationship. - correct
answer strong
The Crow's foot symbol with two vertical parallel lines indicates ______ cardinality. -
correct answer (1,1)
