SADCW-6ed Chapter 12 Databases, Controls, and Security

SADCW-6ed Chapter 12: Databases, Controls, and Security


TRUE/FALSE

1. A relation describes the structure, content, and access controls of a physical data store or database.

ANS: F PTS: 1 REF: p373

2. A relational database management system stores data in tables.

ANS: T PTS: 1 REF: p374

3. Every table in a relational database must have a foreign key.

ANS: F PTS: 1 REF: p375

4. A foreign key is a field or set of fields stored in one table that also exists as a primary key in another
table.

ANS: T PTS: 1 REF: p375

5. Invented keys in a relational database are dangerous and require careful scrutiny.

ANS: T PTS: 1 REF: p377

6. Relationships in a relational database are usually represented by embedding a foreign key in each
participating table.

ANS: F PTS: 1 REF: p380

7. Classes that participate in a classification hierarchy can be represented within a relational database as a
set of tables with the primary key of the general class table replicated in the other tables.

ANS: T PTS: 1 REF: p381

8. Classes that participate in a classification relationship can only be represented within a relational
database as a single table containing all the attributes in each class.

ANS: F PTS: 1 REF: p381

9. A relational database table is in third normal form (3NF) if it is in second normal form (2NF) and if
every non-key field is functionally dependent on the primary key.

ANS: F PTS: 1 REF: p386

10. A relational database table is in third normal form (3NF) if it is in second normal form (2NF) and if no
non-key field is functionally dependent on any other non-key field.

ANS: T PTS: 1 REF: p386

11. Problem domain modeling and database normalization are incompatible techniques for relational
database design.

, ANS: F PTS: 1 REF: p383

12. One-to-many and many-to-many relationships are both represented by foreign keys in a relational
database.

ANS: T PTS: 1 REF: p380

13. Referential integrity is a consistent relational database state in which every foreign key value also
exists as a primary key value.

ANS: T PTS: 1 REF: p382

14. The primary purpose of integrity controls is to track external activity.

ANS: F PTS: 1 REF: p392

15. Completeness control is an integrity control that identifies when a value in a field is too large or too
small.

ANS: F PTS: 1 REF: p394


MULTIPLE CHOICE

1. A(n) ____ describes the structure, content, and access controls of a physical data store or database.
a. relation c. schema
b. DBMS d. attribute
ANS: C PTS: 1 REF: p373

2. Which of the following is NOT a component or function of a typical database management system
(DBMS)?
a. Low-level process management c. Application program interface
b. End-user query processor d. Administrative interface
ANS: A PTS: 1 REF: p373

3. In a relational database, a row can be referred to as a(n) ____.
a. field c. attribute
b. tuple d. relation
ANS: B PTS: 1 REF: p374

4. Data elements in a relational database are organized into ____.
a. attributes c. tables
b. objects d. tuples
ANS: C PTS: 1 REF: p375

5. A(n) ____ is a field or set of fields used to uniquely identify each row.
a. primary key c. object identifier
b. foreign key d. attribute
ANS: A PTS: 1 REF: p375