Guide To SQL 9th Edition by Pratt Last Test Bank
Guide To SQL 9th Edition by Pratt Last Test Bank
Guide To SQL 9th Edition by Pratt Last Test Bank
https://testbankpack.com/p/test-bank-for-guide-
to-sql-9th-edition-pratt-111152727x-
9781111527273/
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
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
7. In the one-to-many type of relationship, the word many always indicates a large number.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 24
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
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
POINTS: 1
REFERENCES: 27
15. The same column name can appear in two different tables in a relational database.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 27
16. The statement “A sales rep’s pay class functionally determines his or her pay rate” means that if you know the pay
class, you can determine the pay rate.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: 28
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: False
POINTS: 1
REFERENCES: 32
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: False
POINTS: 1
REFERENCES: 32
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
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
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: False
POINTS: 1
REFERENCES: 48
31. A determinant is any column (or collection of columns) that determines another table.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: 48
Multiple Choice
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
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 7
Chapter 2: Database Design Fundamentals
REFERENCES: 31
43. is the formal term for combining two or more columns to form a primary key.
a. Qualification
b. Joining
c. Normalization
d. Concatenation
ANSWER: d
POINTS: 1
REFERENCES: 42
REFERENCES: 44
47. can occur when there is a column in a table that is dependent on only a portion of the primary key.
a. Qualification
b. Update anomalies
c. Function splitting
d. Determination
ANSWER: b
POINTS: 1
REFERENCES: 43|44
48. Any column (or collection of columns) that determines another column is called a(n) .
a. nonkey column
b. primary key
c. dependency
d. determinant
ANSWER: d
POINTS: 1
REFERENCES: 48
51. In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as .
a. ovals
b. equal signs
c. lines
d. circles
ANSWER: c
POINTS: 1
Cengage Learning Testing, Powered by Cognero Page 9
Chapter 2: Database Design Fundamentals
REFERENCES: 51
Completion
52. A(n) is a person, place, thing, or event for which you want to store and process data.
ANSWER: entity
POINTS: 1
REFERENCES: 23
55. A table’s design should be as simple as possible; you should restrict each position in a table to a single entry by not
allowing multiple entries (called a(n) group) in an individual location in the table.
ANSWER: repeating
POINTS: 1
REFERENCES: 25
59. When you combine a column name with a table name, you are said to 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
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
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
Essay
72. How does a DBMS that follows the relational model handle entities, attributes of entities, and relationships between
entities?
ANSWER: Entities and attributes are fairly simple. Each entity has its own table. The attributes of an entity become
the columns in the table. In a relational model database a one-to-many relationship is represented by
using common columns in two or more tables. More formally, a relation is essentially a two-dimensional
table. Each column in a table should have a unique name, and entries within each column should all
“match” this column name. Also, each row (also called a record or a tuple in some programs) should be
unique. After all, if two rows in a table contain identical data, the second row doesn’t provide any
information that you don’t already have. In addition, for maximum flexibility in manipulating data, the
order in which columns and rows appear in a table should be immaterial. Finally, a table’s design should
be as simple as possible; you should restrict each position in a table to a single entry by not allowing
multiple entries (called a repeating group) in an individual location in the table.
POINTS: 1
REFERENCES: 23|26
75. What are the six steps necessary to design a database for a set of requirements?
ANSWER: 1. Read the requirements, identify the entities (objects) involved, and name the entities.
2. Identify the unique identifiers for the entities identified in step 1.
3. Identify the attributes for all the entities.
4. Identify the functional dependencies that exist among the attributes.
5. Use the functional dependencies to identify the tables by placing each attribute with the attribute or
minimum combination of attributes on which it is functionally dependent.
6. Identify any relationships between tables.
POINTS: 1
REFERENCES: 32|33