WGU C175 - LESSON 4: QUIZ BLANK/MC QUESTIONS
WITH VERIFIED ANSWERS
The Crow's Foot notation depicts the strong relationship with a(n) _____ line between
the entities. - Answers - solid
A _____ relationship exists when an association is maintained within a single entity.
A strong
B weak
C unary
D ternary - Answers - unary
_____ are underlined in an ER diagram. - Answers - Primary keys
A(n) _____ process is based on repetition of processes and procedures. - Answers -
iterative
Knowing the minimum and maximum number of _____ occurrences is very helpful at
the application software level.
A entity
B data
C attribute
D object - Answers - entity
The entity relationship model uses the associative entity to represent a(n) _____
relationship between two or more entities.
A M:1
B M:N
C 1:M
D N:1 - Answers - M:N
A(n) _____ relationship is also known as an identifying relationship. - Answers - strong
A(n) _____ attribute is an attribute that must have a value. - Answers - required
A _____ attribute is one that cannot be subdivided.
A simple
B single-valued
C multivalued
D composite - Answers - simple
The existence of a(n) _____ entity indicates that its minimum cardinality is zero.
, A weak
B ternary
C optional
D strong - Answers - optional
To simplify the conceptual design, most higher-order relationships are decomposed into
appropriate equivalent _____ relationships whenever possible.
A unary
B binary
C strong
D weak - Answers - binary
The Crow's foot symbol with two vertical parallel lines indicates _____ cardinality.
A (1,1)
B (1,N)
C (0,N)
D (0,1) - Answers - (1,1)
The first step in building an entity-relationship diagram (ERD) is _____ .
A identifying the business rules based on the description of operations
B identifying the attributes and primary keys that adequately describe the entities
C creating a detailed narrative of the organization's description of operations
D developing the initial ERD - Answers - creating a detailed narrative of the
organization's description of operations
When the specific cardinalities are not included on the diagram in Crow's Foot notation,
cardinality is implied by the use of _____.
A images
B attributes
C symbols
D tables - Answers - symbols
Participation is _____ if one entity occurrence does not require a corresponding entity
occurrence in a particular relationship. - Answers - optional
A person's Social Security number would be an example of a(n) _____ attribute. -
Answers - single valued
When using the Crow's Foot notation, the associative entity is indicated by _____
relationship lines between the parents and the associative entity.
A triple
B solid
C dotted
D double - Answers - solid
WITH VERIFIED ANSWERS
The Crow's Foot notation depicts the strong relationship with a(n) _____ line between
the entities. - Answers - solid
A _____ relationship exists when an association is maintained within a single entity.
A strong
B weak
C unary
D ternary - Answers - unary
_____ are underlined in an ER diagram. - Answers - Primary keys
A(n) _____ process is based on repetition of processes and procedures. - Answers -
iterative
Knowing the minimum and maximum number of _____ occurrences is very helpful at
the application software level.
A entity
B data
C attribute
D object - Answers - entity
The entity relationship model uses the associative entity to represent a(n) _____
relationship between two or more entities.
A M:1
B M:N
C 1:M
D N:1 - Answers - M:N
A(n) _____ relationship is also known as an identifying relationship. - Answers - strong
A(n) _____ attribute is an attribute that must have a value. - Answers - required
A _____ attribute is one that cannot be subdivided.
A simple
B single-valued
C multivalued
D composite - Answers - simple
The existence of a(n) _____ entity indicates that its minimum cardinality is zero.
, A weak
B ternary
C optional
D strong - Answers - optional
To simplify the conceptual design, most higher-order relationships are decomposed into
appropriate equivalent _____ relationships whenever possible.
A unary
B binary
C strong
D weak - Answers - binary
The Crow's foot symbol with two vertical parallel lines indicates _____ cardinality.
A (1,1)
B (1,N)
C (0,N)
D (0,1) - Answers - (1,1)
The first step in building an entity-relationship diagram (ERD) is _____ .
A identifying the business rules based on the description of operations
B identifying the attributes and primary keys that adequately describe the entities
C creating a detailed narrative of the organization's description of operations
D developing the initial ERD - Answers - creating a detailed narrative of the
organization's description of operations
When the specific cardinalities are not included on the diagram in Crow's Foot notation,
cardinality is implied by the use of _____.
A images
B attributes
C symbols
D tables - Answers - symbols
Participation is _____ if one entity occurrence does not require a corresponding entity
occurrence in a particular relationship. - Answers - optional
A person's Social Security number would be an example of a(n) _____ attribute. -
Answers - single valued
When using the Crow's Foot notation, the associative entity is indicated by _____
relationship lines between the parents and the associative entity.
A triple
B solid
C dotted
D double - Answers - solid
