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
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