01: Database Normalization and Ref

Chapter 1: Overview of Database Concepts

TRUE/FALSE

1. A database is a physical storage device for data.

ANS: F PTS: 1 REF: 2

2. A field is a basic unit of data also referred to as a record.

ANS: F PTS: 1 REF: 3

3. A character is a basic unit of data and can consist of a number, letter, or special symbol.

ANS: T PTS: 1 REF: 3

4. A collection of fields is a file.

ANS: F PTS: 1 REF: 3

5. A collection of records is a file.

ANS: T PTS: 1 REF: 3

6. A field in the logical design of a database corresponds to a row in the physical table of a relational database.

ANS: F PTS: 1 REF: 3

7. A record in the logical design of a database corresponds to a row in the physical table of a relational database.

ANS: T PTS: 1 REF: 3

8. The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

ANS: T PTS: 1 REF: 4

9. An entity is represented by a column in the Entity-Relationship Model.

ANS: F PTS: 1 REF: 5

10. Only one type of relationship can be represented in an Entity-Relationship Model.

ANS: F PTS: 1 REF: 5

11. The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.

ANS: T PTS: 1 REF: 5-6

12. A one-to-many relationship cannot be included in a relational database.

ANS: F PTS: 1 REF: 6

13. A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.

ANS: F PTS: 1 REF: 6

14. Data redundancy is created through a process known as normalization.

ANS: F PTS: 1 REF: 7-8

15. If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

ANS: F PTS: 1 REF: 9

16. Partial dependency can only exist if the data is uniquely identified by a composite primary key.

ANS: T PTS: 1 REF: 9

17. Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

ANS: F PTS: 1