Module 03: Data and Business Intelligence
can be performed on data, such as updating and querying data. See 3-2: Logical Database
Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
38. is a component of a data model that defines the boundaries of a database, such as maximum and minimum
values allowed for a field, constraints, and access methods.
a. Data structure
b. Schema diagrams
c. Integrity rules
d. File procedure
ANSWER: c
RATIONALE: Correct. Integrity rules is a component of a data model that defines the boundaries of a
database, such as maximum and minimum values allowed for a field, constraints (limits on
what type of data can be stored in a field), and access methods. See 3-2: Logical Database
Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Remember
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
39. In a(n) , nodes with the same parents are called twins or siblings.
a. hierarchical model
b. network model
c. relational model
d. object-based model
ANSWER: a
RATIONALE: Correct. In a hierarchical model, nodes with the same parents are called twins or siblings.
In this model, the relationships among records form a treelike structure. See 3-2: Logical
Database Design
POINTS: 1
Copyright Cengage Learning. Powered by Cognero. Page 17
,Module 03: Data and Business Intelligence
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
40. In the context of data models, relationships among records in a hierarchical model are called .
a. nodes
b. branches
c. roots
d. segments
ANSWER: b
RATIONALE: Correct. In a hierarchical model, records are called nodes, and relationships among records
are called branches. See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
41. In a(n) , each record can have multiple parent and child records.
a. network model
b. hierarchical model
c. object-oriented model
d. relational model
ANSWER: a
RATIONALE: Correct. In a network model, each record can have multiple parent and child records. For
example, a customer can have several invoices, and an invoice can be paid by more than
one method. See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
Copyright Cengage Learning. Powered by Cognero. Page 18
,Module 03: Data and Business Intelligence
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
42. In a relational database model, the rows are called .
a. tuples
b. attributes
c. branches
d. roots
ANSWER: a
RATIONALE: Correct. In a relational database model, the rows are records (also called tuples), and the
columns are fields (also called attributes). See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
43. In a relational database model, the columns are called .
a. attributes
b. tuples
c. branches
d. roots
ANSWER: a
RATIONALE: Correct. In a relational database model, the rows are records (also called tuples), and the
columns are fields (also called attributes). See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
44. To begin designing a relational database, you must define the by defining each table and the fields in it.
Copyright Cengage Learning. Powered by Cognero. Page 19
, Module 03: Data and Business Intelligence
a. physical structure
b. logical structure
c. primary key
d. foreign key
ANSWER: b
RATIONALE: Correct. To begin designing a relational database, you must define the logical structure by
defining each table and the fields in it. For example, a Students table has fields for
StudentID, StudentFirstName, StudentLastName, and so forth. See 3-2: Logical Database
Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
45. The stores data types for fields, default values for fields, and validation rules for data in each field.
a. data dictionary
b. data mine
c. data warehouse
d. data mart
ANSWER: a
RATIONALE: Correct. The data dictionary stores definitions, such as data types for fields, default values,
and validation rules for data in each field. See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
46. In a relational database model, a is a field in a relational table that matches the primary key column of another
table.
a. secondary key
b. foreign key
c. serial key
d. domain key
Copyright Cengage Learning. Powered by Cognero. Page 20
can be performed on data, such as updating and querying data. See 3-2: Logical Database
Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
38. is a component of a data model that defines the boundaries of a database, such as maximum and minimum
values allowed for a field, constraints, and access methods.
a. Data structure
b. Schema diagrams
c. Integrity rules
d. File procedure
ANSWER: c
RATIONALE: Correct. Integrity rules is a component of a data model that defines the boundaries of a
database, such as maximum and minimum values allowed for a field, constraints (limits on
what type of data can be stored in a field), and access methods. See 3-2: Logical Database
Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Remember
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
39. In a(n) , nodes with the same parents are called twins or siblings.
a. hierarchical model
b. network model
c. relational model
d. object-based model
ANSWER: a
RATIONALE: Correct. In a hierarchical model, nodes with the same parents are called twins or siblings.
In this model, the relationships among records form a treelike structure. See 3-2: Logical
Database Design
POINTS: 1
Copyright Cengage Learning. Powered by Cognero. Page 17
,Module 03: Data and Business Intelligence
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
40. In the context of data models, relationships among records in a hierarchical model are called .
a. nodes
b. branches
c. roots
d. segments
ANSWER: b
RATIONALE: Correct. In a hierarchical model, records are called nodes, and relationships among records
are called branches. See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
41. In a(n) , each record can have multiple parent and child records.
a. network model
b. hierarchical model
c. object-oriented model
d. relational model
ANSWER: a
RATIONALE: Correct. In a network model, each record can have multiple parent and child records. For
example, a customer can have several invoices, and an invoice can be paid by more than
one method. See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
Copyright Cengage Learning. Powered by Cognero. Page 18
,Module 03: Data and Business Intelligence
TOPICS: Database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
42. In a relational database model, the rows are called .
a. tuples
b. attributes
c. branches
d. roots
ANSWER: a
RATIONALE: Correct. In a relational database model, the rows are records (also called tuples), and the
columns are fields (also called attributes). See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
43. In a relational database model, the columns are called .
a. attributes
b. tuples
c. branches
d. roots
ANSWER: a
RATIONALE: Correct. In a relational database model, the rows are records (also called tuples), and the
columns are fields (also called attributes). See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
44. To begin designing a relational database, you must define the by defining each table and the fields in it.
Copyright Cengage Learning. Powered by Cognero. Page 19
, Module 03: Data and Business Intelligence
a. physical structure
b. logical structure
c. primary key
d. foreign key
ANSWER: b
RATIONALE: Correct. To begin designing a relational database, you must define the logical structure by
defining each table and the fields in it. For example, a Students table has fields for
StudentID, StudentFirstName, StudentLastName, and so forth. See 3-2: Logical Database
Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
45. The stores data types for fields, default values for fields, and validation rules for data in each field.
a. data dictionary
b. data mine
c. data warehouse
d. data mart
ANSWER: a
RATIONALE: Correct. The data dictionary stores definitions, such as data types for fields, default values,
and validation rules for data in each field. See 3-2: Logical Database Design
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Explain logical database design and the relational database model.
QUESTION TYPE: Multiple Choice
HAS VARIABLES: False
LEARNING OBJECTIVES: MIS.10e.3.2
TOPICS: Relational database design
KEYWORDS: Understand
DATE CREATED: 10/22/2019 1:28 PM
DATE MODIFIED: 10/22/2019 1:28 PM
46. In a relational database model, a is a field in a relational table that matches the primary key column of another
table.
a. secondary key
b. foreign key
c. serial key
d. domain key
Copyright Cengage Learning. Powered by Cognero. Page 20
