,DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
Database Concepts, 8e (Kroenke)
Chapter 2 The Relational Model
1) A key must be unique.
Answer: FALSE
Diff: 1 Page Ref: 74
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
2) Ensuring that every value of a foreign key matches a value of the corresponding primary key
is an example of a referential integrity constraint.
Answer: TRUE
Diff: 1 Page Ref: 80
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
3) A double arrow notation, A →→ B, is used to indicate a multivalued dependency.
Answer: TRUE
Diff: 2 Page Ref: 96
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
4) Microsoft Access forms can only contain data from one table.
Answer: FALSE
Diff: 1 Page Ref: 115
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
5) Which of the following terms is synonymous with "tuple"?
A) Attribute
B) Table
C) Field
D) Row
E) Relation
Answer: D
Diff: 1 Page Ref: 73
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
1
Copyright © 2018 Pearson Education, Inc.
mynursytest.store
,DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
6) Which of the following is not true about null values?
A) A null value can mean that the value is unknown.
B) A null value is ambiguous.
C) A null value can mean that the value is known to be blank.
D) A null value can mean that no value for the field is appropriate.
E) Null values cannot be avoided.
Answer: E
Diff: 2 Page Ref: 83-84
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
7) Explain the terms relation, tuple, and attribute.
Answer: The terms relation, tuple, and attribute are used primarily by database theoreticians.
These terms are synonymous with the terms table, row, and column, respectively, in regards to a
relational database. They are also equivalent to the terms file, record, and field, which tend to be
used by many traditional data processing professionals.
Diff: 1 Page Ref: 73
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
8) Explain the possible interpretations of a null value.
Answer: The problem with allowing null values in a table is that the null value is open to three
different interpretations. First, a null value in a field may mean that no value is appropriate for
the field for the given record. Second, a null value may mean that the value of that field is known
to be blank for the given record. Third, a null value may mean that the value of that field is not
known for the given record.
Diff: 1 Page Ref: 83-84
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
9) While the relational model for databases appears to hold much promise, few commercial
databases have implemented it.
Answer: FALSE
Diff: 1 Page Ref: 70
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
10) Every cell in a relation can hold only a single value.
Answer: TRUE
Diff: 1 Page Ref: 71
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
2
Copyright © 2018 Pearson Education, Inc.
mynursytest.store
, DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
11) In the relational model, each row of a table contains data that represents an attribute of the
entity.
Answer: FALSE
Diff: 2 Page Ref: 71
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
12) Which of the following terms is synonymous with "relation"?
A) Attribute
B) Table
C) Record
D) Row
E) Tuple
Answer: B
Diff: 1 Page Ref: 70
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
13) ________ was the developer of the relational model for databases.
Answer: E. F. Codd
Diff: 1 Page Ref: 70
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
14) Although Microsoft Access is a personal database, the database tables in Access are still
subject to ________ if they are not well-formed.
Answer: modification problems
Diff: 1 Page Ref: 101
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
15) To be considered a composite key, a key must contain at least two attributes.
Answer: TRUE
Diff: 1 Page Ref: 74
AACSB: Information Technology
Chapter Obj: Learn the meaning and importance of keys, foreign keys, and related terminology
Classification: Concept
3
Copyright © 2018 Pearson Education, Inc.
mynursytest.store
Database Concepts, 8e (Kroenke)
Chapter 2 The Relational Model
1) A key must be unique.
Answer: FALSE
Diff: 1 Page Ref: 74
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
2) Ensuring that every value of a foreign key matches a value of the corresponding primary key
is an example of a referential integrity constraint.
Answer: TRUE
Diff: 1 Page Ref: 80
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
3) A double arrow notation, A →→ B, is used to indicate a multivalued dependency.
Answer: TRUE
Diff: 2 Page Ref: 96
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
4) Microsoft Access forms can only contain data from one table.
Answer: FALSE
Diff: 1 Page Ref: 115
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
5) Which of the following terms is synonymous with "tuple"?
A) Attribute
B) Table
C) Field
D) Row
E) Relation
Answer: D
Diff: 1 Page Ref: 73
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
1
Copyright © 2018 Pearson Education, Inc.
mynursytest.store
,DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
6) Which of the following is not true about null values?
A) A null value can mean that the value is unknown.
B) A null value is ambiguous.
C) A null value can mean that the value is known to be blank.
D) A null value can mean that no value for the field is appropriate.
E) Null values cannot be avoided.
Answer: E
Diff: 2 Page Ref: 83-84
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
7) Explain the terms relation, tuple, and attribute.
Answer: The terms relation, tuple, and attribute are used primarily by database theoreticians.
These terms are synonymous with the terms table, row, and column, respectively, in regards to a
relational database. They are also equivalent to the terms file, record, and field, which tend to be
used by many traditional data processing professionals.
Diff: 1 Page Ref: 73
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
8) Explain the possible interpretations of a null value.
Answer: The problem with allowing null values in a table is that the null value is open to three
different interpretations. First, a null value in a field may mean that no value is appropriate for
the field for the given record. Second, a null value may mean that the value of that field is known
to be blank for the given record. Third, a null value may mean that the value of that field is not
known for the given record.
Diff: 1 Page Ref: 83-84
AACSB: Information Technology
Chapter Obj: Learn basic relational terminology
Classification: Concept
9) While the relational model for databases appears to hold much promise, few commercial
databases have implemented it.
Answer: FALSE
Diff: 1 Page Ref: 70
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
10) Every cell in a relation can hold only a single value.
Answer: TRUE
Diff: 1 Page Ref: 71
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
2
Copyright © 2018 Pearson Education, Inc.
mynursytest.store
, DOWNLOAD THE Test Bank for Database Concepts 8th Edition Kroenke
11) In the relational model, each row of a table contains data that represents an attribute of the
entity.
Answer: FALSE
Diff: 2 Page Ref: 71
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
12) Which of the following terms is synonymous with "relation"?
A) Attribute
B) Table
C) Record
D) Row
E) Tuple
Answer: B
Diff: 1 Page Ref: 70
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
13) ________ was the developer of the relational model for databases.
Answer: E. F. Codd
Diff: 1 Page Ref: 70
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
14) Although Microsoft Access is a personal database, the database tables in Access are still
subject to ________ if they are not well-formed.
Answer: modification problems
Diff: 1 Page Ref: 101
AACSB: Information Technology
Chapter Obj: Learn the conceptual foundation of the relational model
Classification: Concept
15) To be considered a composite key, a key must contain at least two attributes.
Answer: TRUE
Diff: 1 Page Ref: 74
AACSB: Information Technology
Chapter Obj: Learn the meaning and importance of keys, foreign keys, and related terminology
Classification: Concept
3
Copyright © 2018 Pearson Education, Inc.
mynursytest.store
