<p>Full file at http://testbank360.eu/test-bank-concepts-of-database-management-7th-edition-pra
Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra
TRUE/FALSE
1. A relational database handles entities, attributes, and relationships by storing each entity in its own
table.
ANS: T
PTS: 1
REF: 31
2. The attributes of an entity become the rows or records in a table.
ANS: F
PTS: 1
REF: 31
3. A relation is essentially just a two-dimensional table.
ANS: T
PTS: 1
REF: 33
4. In a relation, the order of the columns is immaterial.
ANS: T
PTS: 1
REF: 33
5. In a relation, the order of rows is important.
ANS: F
PTS: 1
REF: 33
6. A relational database is a collection of relations.
ANS: T
PTS: 1
REF: 33
7. An unnormalized relation is a table that has more than one row.
ANS: F
PTS: 1
REF: 33
8. The secondary key provides an important way of distinguishing one row in a table from another.
ANS: F
PTS: 1
REF: 34
9. QBE is a visual approach to writing queries.
ANS: T
PTS: 1
REF: 34
10. Access automatically adds double quotation marks around values in the design grid that are formatted
as Text fields when you run the query or move the insertion point to another cell in the design grid.
ANS: T
PTS: 1
REF: 38
11. The comparison operators are +, *, %, and /.
ANS: F
PTS: 1
REF: 39
12. The comparison operators are also known as relational operators.
Full file at http://testbank360.eu/test-bank-concepts-of-database-management-7th-edition-pra
ANS: T
PTS: 1
REF: 39
13. In an OR criterion, the overall criterion is true if either of the individual criteria is true.
ANS: T
PTS: 1
REF: 39
14. When a field name contains spaces or SQL reserved words, you must enclose the field name in curly
braces ({}).
ANS: F
PTS: 1
REF: 43
15. The concept of grouping means that statistics will be calculated for individual records.
ANS: F
PTS: 1
REF: 46
MULTIPLE CHOICE
1.