WGU C175 PRACTICE EXAM QUESTIONS WITH CORRECT
ANSWERS
Entity-Relationship (E-R) model - ANSWER Diagramming technique for
entities, their attributes, and their relationships
Association between entities is - ANSWER Relationship
Binary relationship is between two - ANSWER Entity types
"Binary" in binary relationship - ANSWER two entity types
Cardinality of a relationship - ANSWER Maximum number of entities that can
be involved in the relationship
Modality of a relationship is - ANSWER Minimum number of entities that can
participate in the relationship
One-to-one binary relationship - ANSWER Involves two entity types
One-to-many binary relationship allows an occurrence of the entity type on the
"one
side" of the relationship to be related to - ANSWER Multiple occurrences of
the entity type on the "many side" of the relationship
Many-to-many binary relationship allows an instance of one entity type to be
related to - ANSWER Multiple instances of another entity type
There is a single parking space for every professor. This is an example of a
_____ relationship. - ANSWER One-to-one binary
, Each professor has an office. The relationship between campus buildings and
professors is a _____ relationship. - ANSWER One-to-many binary (1 can
have many)
Courses and their sections can best be
described as a _____ relationship. - ANSWER one-to-many binary
Relationship between students and the professors who have taught them is a
_____ relationship. - ANSWER one-to-many binary
Intersection data - ANSWER Describes the relationship between two entities in
a many-to-many relationship
All students at a university take many courses; all courses are taken by many
students. The semester in which a student took a course and the grade that the
student received in the course is called _____ data. - ANSWER Intersection
An associative entity is another way of modeling a(n) _____. - ANSWER
many-to-many binary relationship
An one-to-one unary relationship _____. - ANSWER involves a single entity
type
An one-to-many unary relationship allows an instance of the entity type on the
"one side" of the relationship to be associated with _____. - ANSWER several
instances of the same entity type
A many-to-many unary relationship allows an instance of one entity type to be
associated with _____. - ANSWER several instances of the same entity type
A ternary relationship allows an instance of one entity type to associate with
_____. - ANSWER several instances of two other entity types
ANSWERS
Entity-Relationship (E-R) model - ANSWER Diagramming technique for
entities, their attributes, and their relationships
Association between entities is - ANSWER Relationship
Binary relationship is between two - ANSWER Entity types
"Binary" in binary relationship - ANSWER two entity types
Cardinality of a relationship - ANSWER Maximum number of entities that can
be involved in the relationship
Modality of a relationship is - ANSWER Minimum number of entities that can
participate in the relationship
One-to-one binary relationship - ANSWER Involves two entity types
One-to-many binary relationship allows an occurrence of the entity type on the
"one
side" of the relationship to be related to - ANSWER Multiple occurrences of
the entity type on the "many side" of the relationship
Many-to-many binary relationship allows an instance of one entity type to be
related to - ANSWER Multiple instances of another entity type
There is a single parking space for every professor. This is an example of a
_____ relationship. - ANSWER One-to-one binary
, Each professor has an office. The relationship between campus buildings and
professors is a _____ relationship. - ANSWER One-to-many binary (1 can
have many)
Courses and their sections can best be
described as a _____ relationship. - ANSWER one-to-many binary
Relationship between students and the professors who have taught them is a
_____ relationship. - ANSWER one-to-many binary
Intersection data - ANSWER Describes the relationship between two entities in
a many-to-many relationship
All students at a university take many courses; all courses are taken by many
students. The semester in which a student took a course and the grade that the
student received in the course is called _____ data. - ANSWER Intersection
An associative entity is another way of modeling a(n) _____. - ANSWER
many-to-many binary relationship
An one-to-one unary relationship _____. - ANSWER involves a single entity
type
An one-to-many unary relationship allows an instance of the entity type on the
"one side" of the relationship to be associated with _____. - ANSWER several
instances of the same entity type
A many-to-many unary relationship allows an instance of one entity type to be
associated with _____. - ANSWER several instances of the same entity type
A ternary relationship allows an instance of one entity type to associate with
_____. - ANSWER several instances of two other entity types