Exam 1: Chapter 2
4) Data modeling may be the most important part of the systems development process because: A) data characteristics are important in the design of programs and other systems components. B) the data in a system are generally less complex than processes and play a central role in development. C) data are less stable than processes. D) it is the easiest.
Answer: A LO: 2.2: State reasons why many system developers and business leaders believe that data modeling is the most important part of the systems development process with a high return on investment. Difficulty: Easy Classification: Concept AACSB: Information Technology
17) A property or characteristic of an entity type that is of interest to the organization is called a(n): A) attribute. B) coexisting entity. C) relationship. D) cross-function.
Answer: A LO: 2.3: Write good names and definitions for entities, relationships, and attributes. Difficulty: Easy Classification: Concept AACSB: Information Technology
19) A person's name, birthday, and social security number are all examples of: A) attributes. B) entities. C) relationships. D) descriptors.
Answer: A LO: 2.3: Write good names and definitions for entities, relationships, and attributes. Difficulty: Moderate Classification: Concept AACSB: Information Technology
3) A fact is an association between two or more: A) words. B) terms. C) facts. D) nuggets.
Answer: B LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
18) An attribute that must be present for every entity (or relationship) instance is a(n): A) composite attribute. B) required attribute. C) optional attribute. D) multivalued attribute.
Answer: B LO: 2.3: Write good names and definitions for entities, relationships, and attributes. Difficulty: Easy Classification: Concept AACSB: Information Technology
36) A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. A) degree B) cardinality constraint C) counter constraint D) limit
Answer: B LO: 2.5: Model each of the following constructs in an E-R diagram: composite attribute, multivalued attribute, derived attribute, associative entity, identifying relationship, and minimum and maximum cardinality constraints. Difficulty: Easy Classification: Concept AACSB: Information Technology
16) An entity type name should be all of the following EXCEPT: A) concise. B) specific to the organization. C) as short as possible. D) a singular noun.
Answer: C LO: 2.3: Write good names and definitions for entities, relationships, and attributes. Difficulty: Moderate Classification: Concept AACSB: Information Technology
56) An example of a term would be the following sentence: "A student registers for a course."
Answer: FALSE LO: 2.1: Define key terms. Difficulty: Difficult Classification: Concept AACSB: Information Technology
86) A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.
Answer: FALSE LO: 2.5: Model each of the following constructs in an E-R diagram: composite attribute, multivalued attribute, derived attribute, associative entity, identifying relationship, and minimum and maximum cardinality constraints. Difficulty: Easy Classification: Concept AACSB: Information Technology
47) A business rule is a statement that defines or constrains some aspect of the business.
Answer: TRUE LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
55) Data names should always relate to business characteristics.
Answer: TRUE LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
57) A fact is an association between two or more terms.
Answer: TRUE LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
58) A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.
Answer: TRUE LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
59) An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
Answer: TRUE LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
46) The E-R model is used to construct a conceptual model.
Answer: TRUE LO: 2.1: Define key terms. Difficulty: Moderate Classification: Concept AACSB: Information Technology
87) One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.
Answer: TRUE LO: 2.5: Model each of the following constructs in an E-R diagram: composite attribute, multivalued attribute, derived attribute, associative entity, identifying relationship, and minimum and maximum cardinality constraints. Difficulty: Easy Classification: Concept AACSB: Information Technology
44) A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. A) one-to-one B) many-to-many C) one-to-many D) strong
Answer: B LO: 2.7: Convert a many-to-many relationship to an associative entity type. Difficulty: Difficult Classification: Concept AACSB: Information Technology
45) A value that indicates the date or time of a data value is called a: A) value stamp. B) time stamp. C) checkpoint. D) check counter.
Answer: B LO: 2.8: Model simple time-dependent data using time stamps and relationships in an E-R diagram. Difficulty: Moderate Classification: Concept AACSB: Information Technology
85) It is not permissible to associate attributes with relationships.
Answer: FALSE LO: 2.5: Model each of the following constructs in an E-R diagram: composite attribute, multivalued attribute, derived attribute, associative entity, identifying relationship, and minimum and maximum cardinality constraints. Difficulty: Moderate Classification: Concept AACSB: Information Technology
1) The logical representation of an organization's data is called a(n): A) database model. B) entity-relationship model. C) relationship systems design. D) database entity diagram.
Answer: B LO: 2.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology
20) An attribute of an entity that is computed is a(n): A) optional attribute. B) composite attribute. C) derived attribute. D) fuzzy attribute.
Answer: C LO: 2.3: Write good names and definitions for entities, relationships, and attributes. Difficulty: Moderate Classification: Concept AACSB: Information Technology
2) A good data definition will describe all of the characteristics of a data object EXCEPT: A) subtleties. B) examples. C) who determines the value of the data. D) who can delete the data.
Answer: D LO: 2.1: Define key terms. Difficulty: Difficult Classification: Concept AACSB: Information Technology
37) A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. A) optional B) unidirectional C) mandatory link D) mandatory one
Answer: D LO: 2.5: Model each of the following constructs in an E-R diagram: composite attribute, multivalued attribute, derived attribute, associative entity, identifying relationship, and minimum and maximum cardinality constraints. Difficulty: Moderate Classification: Concept AACSB: Information Technology
84) It is desirable that no two attributes across all entity types have the same name.
Answer: TRUE LO: 2.5: Model each of the following constructs in an E-R diagram: composite attribute, multivalued attribute, derived attribute, associative entity, identifying relationship, and minimum and maximum cardinality constraints. Difficulty: Moderate Classification: Concept AACSB: Information Technology