Screenshot_20231116-235914

59. A(n) _____ links tables on the basis of an equality condition that compares specified columns of each table. ANSWER: equijoin DIFFICULTY: Difficulty: Easy REFERENCES: 3-4b Relational Set Operators LEARNING OBJECTIVES: 03.03 - Use relational database operators to manipulate relational table contents 60. A(n) provides a detailed description of all tables found within the user/designer-created database. ANSWER: data dictionary DIFFICULTY: Difficulty: Easy REFERENCES: 3-5 The Data Dictionary and the System Catalog LEARNING OBJECTIVES: 03.04 - Explain the purpose and components of the data dictionary and system catalog 61. The catalog can be described as a detailed system data dictionary that describes all objects within the database, including data about table names, the table’s creator and creation date, the number of columns in each table, the data type corresponding to each column, index filenames, index creators, authorized users, and access privileges. ANSWER: system DIFFICULTY: Difficulty: Easy REFERENCES: 3-5 The Data Dictionary and the System Catalog LEARNING OBJECTIVES: 03.04 - Explain the purpose and components of the data dictionary and system catalog 62. The _____ relationship is the relational database norm. ANSWER: I:M DIFFICULTY: Difficulty: Moderate REFERENCES: 3-6a The 1:M Relationship LEARNING OBJECTIVES: 03.05 - Identify appropriate entities and then the relationships among the entities in the relational database model 63. relati ps cannot be impl d as such in the relational model. ANSWER: M:N DIFFICULTY: Difficulty: Moderate REFERENCES: 3-6c The M:N Relationship LEARNING OBJECTIVES: 03.05 - Identify appropriate entities and then the relationships among the entities in the relational database model 64. If one department chair—a professor—can chair only one department, and one department can have only one department chair. The entities PROFESSOR and DEPARTMENT exhibit a(n) _____ relationship. ANSWER: 1:1 DIFFICULTY: Difficulty: Moderate REFERENCES: 3-6b The 1:1 Relationship LEARNING OBJECTIVES: 03.05 - Identify appropriate entities and then the relationships among the entities in the relational database model 65. One characteristic of generalization hierarchies is that they are implemented as relationships. ANSWER: 1:1 Copynght Cengage Leaming. Powered by Cognero. Page 12 Chapter 03: The Relational Database Model DIFFICULTY: Difficulty: Moderate REFERENCES: 3-6b The 1:1 Relationship LEARNING OBJECTIVES: 03.05 - Identify appropriate entities and then the relationships among the entities in the relational database model 66. The properuse of _____ keys is crucial to controlling data redundancy. ANSWER: foreign DIFFICULTY: Difficulty: Easy REFERENCES: 3-7 Data Redundancy Revisited LEARNING OBJECTIVES: 03.06 - Describe how data redundancy is handled in the relational database model 67. Properdata _____ design requires carefully defined and controlled data redundancies to function properly. ANSWER: warehousing DIFFICULTY: Difficulty: Easy REFERENCES: 3-7 Data Redundancy Revisited LEARNING OBJECTIVES: 03.06 - Describe how data redundancy is handled in the relational database model 68. A(n) ____indexis anindex in which the index key can have only one pointer value (row) associated with it. ANSWER: unique DIFFICULTY: Difficulty: Easy REFERENCES: 3-8 Indexes LEARNING OBJECTIVES: 03.07 - Explain the purpose of indexing in a relational database 69. An index key can have multiple (a composite index). ANSWER: attributes DIFFICULTY: Difficulty: Easy REFERENCES: 3-8 Indexes LEARNING OBJECTIVES: 03.07 - Explain the purpose of indexing in a relational database 70. Dr. Codd’s rule of relational database states that every value in a table is guaranteed to be accessible through a combination of table name, primary key value, and column name. @ O 2