Chapter 2: Database Design Fundamentals
Cengage Learning Testing, Powered by Cognero
Page 1
True / False
1. The process of determining the particular tables and columns that will comprise a database is known as database design.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
21
2. A tabular database is a collection of tables.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
3. A relation is a characteristic or property of an entity.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
4. Because there is a one-to-many relationship between sales reps and customers in the TAL Distributors database, one
sales rep can be associated with zero, one, or more customers.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
24
5. In a relational database, each entity has its own table.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
24
6. A matrix is the association between entities.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
7. In the one-to-many type of relationship, the word many always indicates a large number.
Chapter 2: Database Design Fundamentals
Cengage Learning Testing, Powered by Cognero
Page 2
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
8. In a relational database, relationships are implemented by having common columns in two or more tables.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
25
9. Each column in a table of a relational database should have a distinct name.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
26
10. In a relation, all values in a column are values of the same attribute.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
26
11. A relation is essentially a three-dimensional table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
12. Columns are sometimes called tuples.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
13. The concept of functional dependence is trivial to understanding database concepts.
a.
True
b.
False
ANSWER:
Cengage Learning Testing, Powered by Cognero
Page 4
20. You can indicate a table’s primary key by underlining the column or collection of columns that comprises the primary
key for each table in the database.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
31
21. The definition for a primary key really defines a candidate key as well.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
31
22. Many organizations and institutions are moving toward using Social Security numbers as primary keys because of
privacy issues.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
23. If a table contained both employee numbers and Social Security numbers, both columns would be referred to as
candidate keys.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
31
24. A programmer interviews users, examines existing and proposed documents, and examines organizational policies to
determine exactly the type of data needs the database must support.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
25. It is possible for the computer to generate values that are used as the primary key column.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
32
Cengage Learning Testing, Powered by Cognero
Page 5
26. Normalization is done before creating the database design.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
27. An unnormalized relation is a relation that may contain repeating groups.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
40
28. When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal
form is usually the concatenation of at least two columns.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
42
29. Qualification is an update anomaly.
a.
True
b.
False
ANSWER:
False
POINTS:
1
REFERENCES:
43|44
30. A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of
the primary key.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
31. A determinant is any column (or collection of columns) that determines another table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
Cengage Learning Testing, Powered by Cognero
Page 6
32. The process of determining the particular tables and columns that will comprise a database is known as ____.
a.
normalization
b.
database design
c.
qualification
d.
relational management
ANSWER:
b
POINTS:
1
REFERENCES:
21
33. At TAL Distributors, there is a ____ relationship between sales reps and customers.
a.
one-to-one
b.
one-to-two
c.
one-to-many
d.
many-to–many
ANSWER:
c
POINTS:
1
REFERENCES:
24
34. A(n) ____ is the association between entities.
a.
qualification
b.
functional dependency
c.
relationship
d.
join
ANSWER:
c
POINTS:
1
REFERENCES:
24
35. A(n) ____ is a property of an entity.
a.
field
b.
attribute
c.
column
d.
All of the above
ANSWER:
d
POINTS:
1
REFERENCES:
24|26
36. In a relational database each ____ should be unique.
a.
row
b.
record
c.
tuple
d.
All of the above
ANSWER:
d
POINTS:
1
REFERENCES:
24|26
Cengage Learning Testing, Powered by Cognero
Page 7
37. There is a commonly accepted shorthand representation to show the structure of a relational database: After the name
of the table, all the columns in the table are listed within a set of ____.
a.
square brackets
b.
parentheses
c.
back slashes
d.
curly braces
ANSWER:
b
POINTS:
1
REFERENCES:
26
38. A field is another term for a(n) ____.
a.
tuple
b.
row
c.
column
d.
entity
ANSWER:
c
POINTS:
1
REFERENCES:
26
39. A record is another term for a(n) ____.
a.
row
b.
field
c.
attribute
d.
property
ANSWER:
a
POINTS:
1
REFERENCES:
26
40. Which of the following symbols is used to qualify column names?
a.
period (.)
b.
comma (,)
c.
backslash (/)
d.
pound sign (#)
ANSWER:
a
POINTS:
1
REFERENCES:
27
41. Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED,
QUOTED_PRICE) table?
a.
ORDER_NUM
b.
ITEM_NUM
c.
QUOTED_PRICE
d.
ORDER_NUM and ITEM_NUM
ANSWER:
d
POINTS:
1
Cengage Learning Testing, Powered by Cognero
Page 11
60. When you write a column in the format CUSTOMER.REP_NUM, you say that you ____________________ the
column name.
ANSWER:
qualify
POINTS:
1
REFERENCES:
27
61. In a relational database, column B is ____________________ on another column A, if at any point in time a value for
A determines a single value for B.
ANSWER:
functionally dependent
POINTS:
1
REFERENCES:
28
62. If B is functionally dependent on A, you also can say that A functionally ____________________ B.
ANSWER:
determines
POINTS:
1
REFERENCES:
28
63. The ____________________ key of a table (relation) is the column or collection of columns that uniquely identifies a
given row in that table.
ANSWER:
primary
POINTS:
1
REFERENCES:
30
64. A relation is in ____________________ normal form if it does not contain any repeating groups.
ANSWER:
first
1NF
POINTS:
1
REFERENCES:
40
65. The four categories of update anomalies are additions, deletions, inconsistent data, and ____________________.
ANSWER:
updates
POINTS:
1
REFERENCES:
43|44
66. A(n) ____________________ column is a column that is not part of the primary key.
ANSWER:
nonkey
POINTS:
1
REFERENCES:
44
67. If the primary key of a table contains only a single column, the table is automatically in ____________________
normal form.
ANSWER:
second
POINTS:
1
REFERENCES:
44
68. ______________________________ is another name given to third normal form in this text.
Chapter 2: Database Design Fundamentals
ANSWER:
BCNF (Boyce-Codd normal form)
Boyce-Codd normal form (BCNF)
Boyce-Codd
BCNF
POINTS:
1
REFERENCES:
48
69. In one style of entity-relationship (E–R) diagrams, a crow’s foot is used to represent the ____________________ side
of a relationship.
ANSWER:
many
POINTS:
1
REFERENCES:
52
70. In one style of entity-relationship (E–R) diagrams, the letter n is used to represent the ____________________ side of
a relationship.
ANSWER:
many
POINTS:
1
REFERENCES:
52
71. In one style of entity-relationship (E–R) diagrams, diamonds are used to describe ____________________.
ANSWER:
relationships
POINTS:
1
REFERENCES:
52
POINTS:
1
REFERENCES:
23|26