TEST BANK
Concepts of Database Management
by Lisa Friedrichsen, Lisa Ruffolo
N
10th Edition
U
R
SE
TE
ST
HGFDSA
, SDFGHJKL
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.
N
a. Data security
U
b. Data inconsistency
c. Data independence
R
d. Data redundancy
2. Which of the following is not a problem associated with redundancy?
SE
a. prevents orphan records
b. makes updating data more cumbersome and time-consuming
c. can lead to inconsistencies
TE
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
ST
b. entity
c. relationship
d. flat file
4. A(n) is a characteristic or property of an entity.
a. metadata
b. database
HGFDSA
, SDFGHJKL
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
N
b. one-to-many relationship (for second blank)
c. relationship (for first blank)
U
d. attribute
6. A(n) is a structure that contains data about many categories of information as well as the
R
relationships between those categories.
SE
a. table
b. data file
c. relational database
TE
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.
ST
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
HGFDSA
, SDFGHJKL
All Chapters solutions are given in this
PDF however some extra files are
available too with solutions set.
N
U
You can copy and paste below link to
download extra files for solutions
R
SE
https://www.mediafire.com/file/
TE
dbmdqrk25cqmqtd/Extra+Files+-
+Concepts+of+Database+Management
+10e.rar/file
ST
HGFDSA