2
C175 Practice Test questions with verified detailed
|| || || || || || ||
solutions
Entity-Relationship (E-R) model - ✔✔Diagramming technique for entities, their attributes, || || || || || || || || || ||
and their relationships
|| ||
Association between entities is - ✔✔Relationship || || || || ||
Binary relationship is between two - ✔✔Entity types
|| || || || || || ||
"Binary" in binary relationship - ✔✔two entity types
|| || || || || || ||
Cardinality of a relationship - ✔✔Maximum number of entities that can be involved in the
|| || || || || || || || || || || || || || ||
relationship
Modality of a relationship is - ✔✔Minimum number of entities that can be involved in the
|| || || || || || || || || || || || || || || ||
relationship
One-to-one binary relationship - ✔✔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 associated with - ✔✔Multiple occurrences of the entity type
|| || || || || || || || || || || || || || ||
on the "many side" of the relationship
|| || || || || ||
Many-to-many binary relationship allows an occurrence of one entity type to be
|| || || || || || || || || || ||
associated with - ✔✔Multiple occurrences of another entity type
|| || || || || || || ||
, 2
Each professor is entitled to one parking space. This is an example of a _____ relationship. -
|| || || || || || || || || || || || || || || || ||
✔✔One-to-one binary ||
Each professor has one office. The relationship between campus buildings and professors is
|| || || || || || || || || || || || ||
a _____ relationship. - ✔✔One-to-many binary (1 can have many)
|| || || || || || || || ||
Courses and their sections can best be || || || || || ||
described as a _____ relationship. - ✔✔one-to-many binary
|| || || || || || ||
Relationship between students and the professors who have been their instructors is a
|| || || || || || || || || || || || ||
_____ relationship. - ✔✔one-to-many binary
|| || || ||
Intersection data - ✔✔Describes the relationship between two entities in a many-to-many
|| || || || || || || || || || || ||
relationship
Each student at a university takes many courses; each course is taken by many students.
|| || || || || || || || || || || || || || ||
The semester that a student took a course and the grade that the student received in the
|| || || || || || || || || || || || || || || || ||
course is called _____ data. - ✔✔Intersection
|| || || || || ||
An associative entity is an alternate way of expressing a(n) _____. - ✔✔many-to-many
|| || || || || || || || || || || || ||
binary relationship ||
An one-to-one unary relationship _____. - ✔✔involves a single entity type
|| || || || || || || || || ||
An one-to-many unary relationship allows an occurrence of the entity type on the "one side"
|| || || || || || || || || || || || || ||
of the relationship to be associated with _____. - ✔✔multiple occurrences of the same
|| || || || || || || || || || || || || || ||
entity type ||
C175 Practice Test questions with verified detailed
|| || || || || || ||
solutions
Entity-Relationship (E-R) model - ✔✔Diagramming technique for entities, their attributes, || || || || || || || || || ||
and their relationships
|| ||
Association between entities is - ✔✔Relationship || || || || ||
Binary relationship is between two - ✔✔Entity types
|| || || || || || ||
"Binary" in binary relationship - ✔✔two entity types
|| || || || || || ||
Cardinality of a relationship - ✔✔Maximum number of entities that can be involved in the
|| || || || || || || || || || || || || || ||
relationship
Modality of a relationship is - ✔✔Minimum number of entities that can be involved in the
|| || || || || || || || || || || || || || || ||
relationship
One-to-one binary relationship - ✔✔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 associated with - ✔✔Multiple occurrences of the entity type
|| || || || || || || || || || || || || || ||
on the "many side" of the relationship
|| || || || || ||
Many-to-many binary relationship allows an occurrence of one entity type to be
|| || || || || || || || || || ||
associated with - ✔✔Multiple occurrences of another entity type
|| || || || || || || ||
, 2
Each professor is entitled to one parking space. This is an example of a _____ relationship. -
|| || || || || || || || || || || || || || || || ||
✔✔One-to-one binary ||
Each professor has one office. The relationship between campus buildings and professors is
|| || || || || || || || || || || || ||
a _____ relationship. - ✔✔One-to-many binary (1 can have many)
|| || || || || || || || ||
Courses and their sections can best be || || || || || ||
described as a _____ relationship. - ✔✔one-to-many binary
|| || || || || || ||
Relationship between students and the professors who have been their instructors is a
|| || || || || || || || || || || || ||
_____ relationship. - ✔✔one-to-many binary
|| || || ||
Intersection data - ✔✔Describes the relationship between two entities in a many-to-many
|| || || || || || || || || || || ||
relationship
Each student at a university takes many courses; each course is taken by many students.
|| || || || || || || || || || || || || || ||
The semester that a student took a course and the grade that the student received in the
|| || || || || || || || || || || || || || || || ||
course is called _____ data. - ✔✔Intersection
|| || || || || ||
An associative entity is an alternate way of expressing a(n) _____. - ✔✔many-to-many
|| || || || || || || || || || || || ||
binary relationship ||
An one-to-one unary relationship _____. - ✔✔involves a single entity type
|| || || || || || || || || ||
An one-to-many unary relationship allows an occurrence of the entity type on the "one side"
|| || || || || || || || || || || || || ||
of the relationship to be associated with _____. - ✔✔multiple occurrences of the same
|| || || || || || || || || || || || || || ||
entity type ||
