Albany State University

MGMT 4206

Chapter 2: Data Modeling Multiple Choice

1)The Entity-Relationship (E-R) model is                             .

1. 1. a diagramming technique that describes record structures (i.e. the fields that make up the records of a file)
   2. an alternative to indexing and hashing as a means for providing direct access in files
   3. a diagramming technique that describes entities, their attributes, and the relationships between them
   4. an alternative to file design in which attributes are used instead of fields
   5. 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)                   .
   1. entity type
   2. entity occurence
   3. record
   4. attribute
   5. relationship

 

 

 

3. A binary relationship is a relationship between two                     .
   1. entity types
   2. attribute types
   3. associations
   4. files
   5. cardinalities

 

 

4. The term “binary” in binary relationship indicates that the relationship is between
   1. two halves of an entity type
   2. two entity types
   3. two divisions of an entity’s attributes
   4. two attributes
   5. two relationships

 

 

5. The cardinality of a relationship is                    .
   1. The minimum number of entities that can be involved in the relationship.
   2. The maximum number of entities that can be involved in the relationship.
   3. The minimum number of attributes that can be in the entity types in a relationship.

1. 4. The maximum number of attributes that can be in the entity types in a relationship.
   5. The minimum number of associations that can be involved in the relationship.

 

 

6. The modality of a relationship is                   .
   1. The minimum number of entities that can be involved in the relationship.
   2. The maximum number of entities that can be involved in the relationship.
   3. The minimum number of attributes that can be in the entity types in a relationship.
   4. The maximum number of attributes that can be in the entity types in a relationship.
   5. The minimum number of associations that can be involved in the relationship.

 

 

7. A one-to-one binary relationship                  .
   1. involves a single entity type
   2. involves two entity types
   3. allows an occurrence of one entity type to be associated with several occurrences of another entity type
   4. allows an occurrence of one entity type to be associated with several occurrences of another entity type and vice versa
   5. 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                   .
   1. a single occurrence of the same entity type
   2. multiple occurrences of the same entity type
   3. a single occurrence of the entity type on the “many side” of the relationship
   4. multiple occurrences of the entity type on the “many side” of the relationship
   5. 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                                                                                                                                                                                                                     .
   1. a single occurrence of the same entity type
   2. multiple occurrences of the same entity type
   3. a single occurrence of another entity type
   4. multiple occurrences of another entity type
   5. 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.
    1. one-to-one binary
    2. one-to-many binary
    3. many-to-many binary
    4. one-to-one unary
    5. 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.
    1. one-to-one binary
    2. one-to-many binary
    3. many-to-many binary
    4. one-to-one unary
    5. one-to-many unary
12. In a university, the relationship between courses and their sections can best be described as a                           

relationship.

1. 1. one-to-one binary
   2. one-to-many binary
   3. many-to-many binary
   4. one-to-one unary
   5. one-to-many unary

 

 

13. In a university setting, the relationship between students and the professors who have been their instructors is a                  relationship.
    1. one-to-one binary
    2. one-to-many binary
    3. many-to-many binary
    4. one-to-one unary
    5. one-to-many unary

 

 

14. Intersection data                 .
    1. is an attribute of the entity on the “one side” of a one-to-many relationship
    2. is an attribute of the entity on the “many side” of a one-to-many relationship
    3. describes the relationship between two entities in a many-to-many relationship
    4. describes one of the entities in a many-to-many relationship
    5. 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.
    1. index
    2. key
    3. pointer
    4. direct access
    5. intersection

 

 

16. An associative entity is an alternate way of expressing a(n)                      .

1. 1. one-to-one binary relationship
   2. one-to-many binary relationship
   3. many-to-many binary relationship
   4. entity that has no attributes other than the unique identifier or key
   5. entity that has no unique identifiers or keys

 

 

17. Depending on the attributes and circumstances present, the unique identifier of an associative entity could be any of the following, except                        .
    1. the combination of the unique identifiers of the entities in the many-to-many relationship consisting of exactly one field from each entity
    2. the combination of the unique identifiers of the entities in the many-to-many relationship consisting of several fields
    3. the combination of the unique identifiers of the entities in the many-to-many relationship plus one or more additional fields that express times or dates
    4. a single field that is associated with the associative entity and provides unique values
    5. a unique combination of fields from one of the two entities in the many-to-many relationship

 

 

18. A one-to-one unary relationship                  .
    1. involves a single entity type
    2. involves two entity types
    3. allows an occurrence of one entity type to be associated with several occurrences of another entity type
    4. allows an occurrence of one entity type to be associated with several occurrences of another entity type and vice versa
    5. allows an occurrence of one entity type to be associated with several occurrences of the same entity type

 

 

19. A one-to-many unary relationship allows an occurrence of the entity type on the “one side” of the relationship to be associated with                   .
    1. a single occurrence of the same entity type
    2. multiple occurrences of the same entity type
    3. a single occurrence of the different entity type on the “many side” of the relationship
    4. multiple occurrences of the different entity type on the “many side” of the relationship
    5. multiple occurrences of the different entity type on the “one side” of the relationship

 

 

20. A many-to-many unary relationship allows an occurrence of one entity type to be associated with                                                                                                                                                                                                                     .
    1. a single occurrence of the same entity type
    2. multiple occurrences of the same entity type
    3. a single occurrence of another entity type
    4. multiple occurrences of another entity type
    5. multiple occurrences of three entity types

 

 

21. A ternary relationship allows an occurrence of one entity type to be associated with                          .
    1. a single occurrence of the same entity type
    2. multiple occurrences of the same entity type
    3. a single occurrence of only one other entity type
    4. multiple occurrences of only one other entity type
    5. multiple occurrences of two other entity types

 

 

22. In a university setting, each student is paired with another student for the purpose of getting assignments and turning in work for the other if he is out of school for any reason. This is a                           relationship.
    1. one-to-one binary
    2. one-to-many binary
    3. many-to-many binary
    4. one-to-one unary
    5. one-to-many unary

 

 

23. In a university setting, every professor reports to another professor who is the department chair. This is a

              relationship.

1. 1. one-to-one binary
   2. one-to-many binary
   3. many-to-many binary
   4. one-to-one unary
   5. one-to-many unary

 

 

24. A university wants to keep track of which professor taught which subject to which student. This is a                                                                                                                                                                                                                                

relationship.

1. 1. one-to-many unary
   2. many-to-many unary
   3. one-to-many binary
   4. many-to-many binary
   5. ternary

 

 

25. A dependent entity                .
    1. is the same as an associative entity
    2. can only exist as part of a many-to-many binary relationship
    3. can only be present if the entity it depends on is present
    4. requires intersection data if it is part of a many-to-many binary relationship
    5. requires intersection data if it is part of a ternary relationship

True/False

26. The Entity-Relationship (E-R) model is designed to diagram entity types that are independent of each other.

 

 

27. The Entity-Relationship (E-R) model is designed to diagram entity types and the relationships between them.

 

 

 

28. A binary relationship is one in which each entity occurrence is associated with exactly two other entity occurrences.

 

 

 

29. A binary relationship is a relationship between two entity types.

 

 

 

30. A one-to-one binary relationship involves a single entity type.

 

 

 

31. A one-to-one binary relationship associates one occurrence of an entity type with one occurrence of another entity type.

 

 

 

32. The cardinality of a relationship is the maximum number of entity occurrences that can be involved in it.

 

 

 

33. The cardinality of a relationship is the maximum number of entity types that can be involved in it.

 

 

 

34. In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

 

 

 

35. In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type.

 

 

 

36. In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

 

 

37. In a many-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with only one occurrence of the first.

 

 

 

38. In a many-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with many occurrences of the first.

 

 

 

39. The modality of a relationship is the minimum number of entity occurrences that can be involved in a relationship.

 

 

 

40. Intersection data describes the many-to-many relationship between two entities.

 

 

 

41. Intersection data is associated with one of the two entities in a many-to-many relationship.

 

 

 

42. An associative entity is an alternate way of describing a one-to-one binary relationship.

 

 

 

43. An associative entity is an alternate way of describing a many-to-many binary relationship.

 

 

 

44. It is possible to have a many-to-many binary relationship without intersection data.

 

 

 

45. It is not necessary to have an associative entity describe a many-to-many binary relationship if there is not intersection data.

 

 

 

46. A one-to-one unary relationship involves a single entity type.

 

 

 

47. A one-to-one unary relationship associates one occurrence of an entity type with one occurrence of another entity type.

 

 

 

48. In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

 

 

 

49. In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

 

 

50. In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with only one occurrence of the first.

 

 

 

51. In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with many occurrences of the first.

 

 

 

52. In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

 

 

 

53. A ternary relationship involves three different entity types.

 

 

 

54. In a ternary relationship, an occurrence of one entity type is associated with exactly three occurrences of another entity type.

 

 

 

55. A dependent entity would be of no use to a business environment if the entity that it depends on is no longer of use.