Concepts of Database Management
10th Edition by Lisa Friedrichsen
Complete Chapter Module
Solutions are included
(Ch 1 to 9)
** Immediate Download
** Swift Response
** All Modules included
** Extra Solutions Files
,Module 1
Introduction to Database Management
Solutions
REVIEW QUESTIONS
1. _____ is the duplication of data or the storing of the same data in more than one place.
a. Data security
b. Data inconsistency
c. Data independence
d. Data redundancy
2. Which of the following is not a problem associated with redundancy?
a. prevents orphan records
b. makes updating data more cumbersome and time-consuming
c. can lead to inconsistencies
d. results in more frequent data errors
3. A(n) _____ is a person, place, object, event, or idea for which you want to store and process data.
a. attribute
b. entity
c. relationship
d. flat file
4. A(n) _____ is a characteristic or property of an entity.
a. metadata
b. database
, c. flat file
d. attribute
5. A(n) _____ is an association between entities. A(n) _____ exists between two entities when each row in
the first entity matches many rows in the second entity, and each row in the second entity matches only
one row in the first entity.
a. record
b. one-to-many relationship (for second blank)
c. relationship (for first blank)
d. attribute
6. A(n) _____ is a structure that contains data about many categories of information as well as the
relationships between those categories.
a. table
b. data file
c. relational database
d. software stack
7. Which of the following describes how to create a one-to-many relationship in a database system?
a. Insert a new table between two existing tables.
b. Use a common field in the two tables to tie the related records from each table together.
c. Create an entity-relationship (E-R) diagram.
d. Include multiple entries in a single field.
8. In a(n) _____, rectangles represent entities and display their attributes; lines represent relationships
between connected entities.
a. entity-relationship (E-R) diagram
b. unstructured data file
10th Edition by Lisa Friedrichsen
Complete Chapter Module
Solutions are included
(Ch 1 to 9)
** Immediate Download
** Swift Response
** All Modules included
** Extra Solutions Files
,Module 1
Introduction to Database Management
Solutions
REVIEW QUESTIONS
1. _____ is the duplication of data or the storing of the same data in more than one place.
a. Data security
b. Data inconsistency
c. Data independence
d. Data redundancy
2. Which of the following is not a problem associated with redundancy?
a. prevents orphan records
b. makes updating data more cumbersome and time-consuming
c. can lead to inconsistencies
d. results in more frequent data errors
3. A(n) _____ is a person, place, object, event, or idea for which you want to store and process data.
a. attribute
b. entity
c. relationship
d. flat file
4. A(n) _____ is a characteristic or property of an entity.
a. metadata
b. database
, c. flat file
d. attribute
5. A(n) _____ is an association between entities. A(n) _____ exists between two entities when each row in
the first entity matches many rows in the second entity, and each row in the second entity matches only
one row in the first entity.
a. record
b. one-to-many relationship (for second blank)
c. relationship (for first blank)
d. attribute
6. A(n) _____ is a structure that contains data about many categories of information as well as the
relationships between those categories.
a. table
b. data file
c. relational database
d. software stack
7. Which of the following describes how to create a one-to-many relationship in a database system?
a. Insert a new table between two existing tables.
b. Use a common field in the two tables to tie the related records from each table together.
c. Create an entity-relationship (E-R) diagram.
d. Include multiple entries in a single field.
8. In a(n) _____, rectangles represent entities and display their attributes; lines represent relationships
between connected entities.
a. entity-relationship (E-R) diagram
b. unstructured data file
