C175 Practice Test
Multiple Choice
1. The Entity-Relationship (E-R) model is _____.
a. a diagramming technique that describes record structures (i.e.
... [Show More] the fields that make
up the records of a file)
b. an alternative to indexing and hashing as a means for providing direct access in
files
c. a diagramming technique that describes entities, their attributes, and the
relationships between them
d. an alternative to file design in which attributes are used instead of fields
e. a diagramming technique that relates entities to each other, attributes to each
other, and relationships to each other
2. An association between entities is a(n) _____.
a. entity type
b. entity occurence
c. record
d. attribute
e. relationship
3. A binary relationship is a relationship between two _____.
a. entity types
b. attribute types
c. associations
d. files
e. cardinalities
4. The term “binary” in binary relationship indicates that the relationship is between
a. two halves of an entity type
b. two entity types
c. two divisions of an entity’s attributes
d. two attributes
e. two relationships
5. The cardinality of a relationship is _____.
a. The minimum number of entities that can be involved in the relationship.
b. The maximum number of entities that can be involved in the relationship.
c. The minimum number of attributes that can be in the entity types in a relationship.
d. The maximum number of attributes that can be in the entity types in a
relationship.e. The minimum number of associations that can be involved in the relationship.
6. The modality of a relationship is _____.
a. The minimum number of entities that can be involved in the relationship.
b. The maximum number of entities that can be involved in the relationship.
c. The minimum number of attributes that can be in the entity types in a relationship.
d. The maximum number of attributes that can be in the entity types in a
relationship.
e. The minimum number of associations that can be involved in the relationship.
7. A one-to-one binary relationship _____.
a. involves a single entity type
b. involves two entity types
c. allows an occurrence of one entity type to be associated with several occurrences
of another entity type
d. allows an occurrence of one entity type to be associated with several occurrences
of another entity type and vice versa
e. restricts the number of attributes that an entity has
8. A one-to-many binary relationship allows an occurrence of the entity type on the “one
side” of the relationship to be associated with _____.
a. a single occurrence of the same entity type
b. multiple occurrences of the same entity type
c. a single occurrence of the entity type on the “many side” of the relationship
d. multiple occurrences of the entity type on the “many side” of the relationship
e. multiple occurrences of the entity type on the “one side” of the relationship
9. A many-to-many binary relationship allows an occurrence of one entity type to be
associated with _____.
a. a single occurrence of the same entity type
b. multiple occurrences of the same entity type
c. a single occurrence of another entity type
d. multiple occurrences of another entity type
e. multiple occurrences of three entity types
10. A business school’s faculty parking lot has assigned parking spaces. Each professor
is entitled to one parking space. This is an example of a _____ relationship.
a. one-to-one binary
b. one-to-many binary
c. many-to-many binary
d. one-to-one unarye. one-to-many unary
11. Each building on a university campus has several faculty offices. Each professor has
one office. The relationship between campus buildings and professors is a _____
relationship.
a. one-to-one binary
b. one-to-many binary
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
12. In a university, the relationship between courses and their sections can best be
described as a _____ relationship.
a. one-to-one binary
b. one-to-many binary (Because a section can NOT have many courses. Think .xls)
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
13. In a university setting, the relationship between students and the professors who have
been their instructors is a _____ relationship.
a. one-to-one binary
b. one-to-many binary (NOTE: “who have been their instructors”)
c. many-to-many binary
d. one-to-one unary
e. one-to-many unary
14. Intersection data _____.
a. is an attribute of the entity on the “one side” of a one-to-many relationship
b. is an attribute of the entity on the “many side” of a one-to-many relationship
c. describes the relationship between two entities in a many-to-many relationship
d. describes one of the entities in a many-to-many relationship
e. describes one of the entities in a ternary relationship
15. 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.
a. index
b. key
c. pointer
d. direct accesse. intersection
16. An associative entity is an alternate way of expressing a(n) _____.
a. one-to-one binary relationship
b. one-to-many binary relationship
c. many-to-many binary relationship
d. entity that has no attributes other than the unique identifier or key
e. entity that has no unique identifiers or keys
17. A one-to-one unary relationship _____.
a. involves a single entity type
b. involves two entity types
c. allows an occurrence of one entity type to be associated with several occurrences
of another entity type
d. allows an occurrence of one entity type to be associated with several occurrences
of another entity type and vice versa
e. allows an occurrence of one entity type to be associated with several occurrences
of the same entity type [Show Less]