Test Bank For Database Systems, Design, Implementation and Management 13th Edition Carlos Coronel Steven morris | Complete ()

A composite identifier is a primary key composed of more than one attribute. a. True b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 9. The Crow's Foot notation easily identifies multivalued attributes. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 10. Composite attributes make it easier to facilitate detailed queries. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 11. Connectivities and cardinalities are established by concise statements known as business rules. a. True b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 3 into the database design process 12. In Chen notation, there is no way to represent cardinality. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 13. In implementation terms, an entity is existence-dependent if it has a mandatory primary key. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1e Existence Dependence LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 14. A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1f Relationship Strength LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 15. A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship. a. True b. False ANSWER: True DIFFICULTY: Difficulty: Easy REFERENCES: 4-1g Weak Entities LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 16. In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first. a. True b. False ANSWER: True DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1f Relationship Strength LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 17. Relationships between entities always operate in one direction. Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 4 a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 18. The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 19. Referential integrity and participation are both bidirectional, meaning that they must be addressed in both directions along a relationship. a. True b. False ANSWER: False DIFFICULTY: Difficulty: Easy REFERENCES: 4-1j Recursive Relationships LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 20. To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional. a. True b. False ANSWER: True DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1k Associative (Composite) Entities LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation Multiple Choice 21. The entity relationship diagram (ERD) represents the _____ database as viewed by the end user. a. condensed b. physical c. logical d. conceptual ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 4-1 The Entity Relationship Model LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 22. The _____ notation of entity-relationship modelling can be used for both conceptual and implementation modelling. a. Bachman b. UML Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 5 c. Chen d. Crow's Foot ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 4-1 The Entity Relationship Model LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 23. A(n) _____ is the set of possible values for a given attribute. a. domain b. range c. identifier d. key ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 24. Ideally, an entity identifier is composed of _____ attribute(s). a. one b. two c. three d. six ANSWER: a DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 25. A _____ attribute can be further subdivided to yield additional attributes. a. composite b. simple c. single-valued d. multivalued ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 26. A _____ attribute is one that cannot be subdivided. a. composite b. simple c. single-valued d. multivalued ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 27. The conceptual model can handle _____ relationships and multivalued attributes. a. 1:1 b. M:N c. 1:M d. 1:N ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 6 28. A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity. a. single line b. dashed line c. double dashed line d. double line ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 29. The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application. a. multivalued b. derived c. single-valued d. composite ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 30. A relationship is an association between _____. a. objects b. entities c. databases d. fields ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 4-1c Relationships LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 31. _____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. a. Connectivity b. Relationship c. Dependence d. Cardinality ANSWER: d DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 32. In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities. a. (max, min) b. (min, max) c. [min ... max] d. {min|max} ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 7 33. When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____. a. symbols b. attributes c. images d. tables ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 34. Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level. a. object b. attribute c. data d. entity ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 35. An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence. a. existence b. relationship c. business d. data ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 4-1e Existence Dependence LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 36. If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) _____ entity. a. weak b. alone c. unary d. strong ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 4-1e Existence Dependence LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 37. A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. a. strong b. weak c. business d. child ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 4-1f Relationship Strength Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 8 LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 38. The existence of a(n) _____ entity indicates that its minimum cardinality is zero. a. ternary b. optional c. strong d. weak ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 39. A _____ relationship exists when an association is maintained within a single entity. a. unary b. ternary c. strong d. weak ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 4-1i Relationship Degree LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 40. A _____ relationship exists when three entities are associated. a. unary b. strong c. ternary d. weak ANSWER: c DIFFICULTY: Difficulty: Easy REFERENCES: 4-1i Relationship Degree LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 41. If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship. a. self b. self-referring c. looping d. recursive ANSWER: d DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1j Recursive Relationships LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 42. To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible. a. unary b. binary c. strong d. weak ANSWER: b DIFFICULTY: Difficulty: Easy Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 9 REFERENCES: 4-1i Relationship Degree LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 43. The entity relationship model uses the associative entity to represent a(n) _____ relationship between two or more entities. a. M:N b. 1:M c. N:1 d. M:1 ANSWER: a DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1k Associative (Composite) Entities LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 44. When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity. a. dotted b. double c. triple d. solid ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 4-1k Associative (Composite) Entities LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 45. The first step in building an entity-relationship diagram (ERD) is _____. a. developing the initial ERD b. creating a detailed narrative of the organization’s description of operations c. identifying the attributes and primary keys that adequately describe the entities d. identifying the business rules based on the description of operations ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 4-2 Developing an ER Diagram LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 46. The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality. a. (0,N) b. (1,N) c. (1,1) d. (0,1) ANSWER: c DIFFICULTY: Difficulty: Easy REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 47. If Tiny College has some departments that are classified as “research only” and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity. a. existence-dependent on b. independent of Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 10 c. mandatory for d. optional to ANSWER: d DIFFICULTY: Difficulty: Moderate REFERENCES: 4-2 Developing an ER Diagram LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 48. In organizations that generate large number of transactions, _____ are often a top priority in database design. a. relationships among entities b. logical design standards c. naming conventions d. high processing speeds ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 4-3 Database Design Challenges: Conflicting Goals LEARNING OBJECTIVES: 04.04 - Understand that real-world database design often requires the reconciliation of conflicting goals 49. Complex _____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. a. information b. entity c. design d. processing ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 4-3 Database Design Challenges: Conflicting Goals LEARNING OBJECTIVES: 04.04 - Understand that real-world database design often requires the reconciliation of conflicting goals 50. Database design is a(n) _____ process based on repetition. a. sequential b. iterative c. linear d. intermittent ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 4-2 Developing an ER Diagram LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process Completion 51. _____ are characteristics of entities. ANSWER: Attributes DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 52. A(n) _____ attribute is an attribute that must have a value. ANSWER: required DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 11 LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 53. _____ are underlined in an ER diagram. ANSWER: Identifiers DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 54. A person’s Social Security number would be an example of a(n) _____ attribute. ANSWER: single-valued DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 55. A(n) _____ attribute need not be physically stored within the database. ANSWER: derived DIFFICULTY: Difficulty: Easy REFERENCES: 4-1b Attributes LEARNING OBJECTIVES: 04.01 - Identify the main characteristics of entity relationship components 56. A relationship _____ is difficult to establish if only one side of the relationship is known. ANSWER: classification DIFFICULTY: Difficulty: Easy REFERENCES: 4-1c Relationships LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 57. When indicating cardinality, the first value represents the _____ number of associated entities. ANSWER: minimum DIFFICULTY: Difficulty: Easy REFERENCES: 4-1d Connectivity and Cardinality LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 58. The concept of relationship strength is based on how the _____ of a related entity is defined. ANSWER: primary key DIFFICULTY: Difficulty: Easy REFERENCES: 4-1f Relationship Strength LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 59. A(n) _____ relationship is also known as an identifying relationship. ANSWER: strong DIFFICULTY: Difficulty: Easy REFERENCES: 4-1f Relationship Strength LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 12 into the database design process 60. The Crow’s Foot notation depicts the strong relationship with a(n) _____ line between the entities. ANSWER: solid DIFFICULTY: Difficulty: Easy REFERENCES: 4-1f Relationship Strength LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 61. A weak entity must be _____-dependent. ANSWER: existence DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1g Weak Entities LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 62. The Chen notation identifies a weak entity by using a double-walled entity _____. ANSWER: rectangle DIFFICULTY: Difficulty: Easy REFERENCES: 4-1g Weak Entities LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 63. Participation is _____ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship. ANSWER: optional DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 64. In Crow’s Foot notation, an optional relationship between entities is shown by drawing a(n) _____ on the side of the optional entity. ANSWER: small circle (O) DIFFICULTY: Difficulty: Easy REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 65. Failure to understand the distinction between mandatory and optional _____ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities. ANSWER: participation DIFFICULTY: Difficulty: Easy REFERENCES: 4-1h Relationship Participation LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process Chapter 04: Entity Relationship (ER) Modeling Copyright Cengage Learning. Powered by Cognero. Page 13 66. A relationship _____ indicates the number of entities or participants associated with a relationship. ANSWER: degree DIFFICULTY: Difficulty: Easy REFERENCES: 4-1i Relationship Degree LEARNING OBJECTIVES: 04.02 - Describe how relationships between entities are defined, refined, and incorporated into the database design process 67. A(n) _____ process is based on repetition of processes and procedures. ANSWER: iterative DIFFICULTY: Difficulty: Easy REFERENCES: 4-2 Developing an ER Diagram LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 68. Identifying the attributes of entities helps in the better understanding of _____ among entities. ANSWER: relationships DIFFICULTY: Difficulty: Easy REFERENCES: 4-2 Developing an ER Diagram LEARNING OBJECTIVES: 04.03 - See how ERD components affect database design and implementation 69. _____ not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design. ANSWER: Documentation DIFFICULTY: Difficulty: Easy REFERENCES: 4-3 Database Design Challenges: Conflicting Goals LEARNING OBJECTIVES: 04.04 - Understand that real-world database design often requires the reconciliation of conflicting goals 70. In organizations that generate large numbers of transactions, _____ processing speeds are often a top priority in database design, which result in minimal access time. ANSWER: high DIFFICULTY: Difficulty: Moderate REFERENCES: 4-3 Database Design Challenges: Conflicting LEARNING OBJECTIVES: 04.04 - Understand that real-world database design often requires the reconciliation of conflicting goals Essay 71. Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model? ANSWER: Multivalued attributes are attributes that can have many values. For instance, a person may have several college degrees, and a household may have several different phones, each with its own number. Similarly, a car's color may be subdivided into many colors for the roof, body, and trim. In the Chen Entity Relationship model, multivalued attributes are shown by a double line connecting the attribute to the entity. DIFFICULTY: Difficulty: Moderate REFERENCES: 4-1b Attributes