Chapter 1: Introduction to Database Management
TRUE/FALSE
1. Redundancy wastes space because you are storing the same data in more than one place.
ANS: T PTS: 1 REF: 2
2. A spreadsheet’s data-sharing features allows multiple employees to update data in one
spreadsheet at the same time.
ANS: F PTS: 1 REF: 2-3
3. An attribute is a characteristic or property of an entity.
ANS: T PTS: 1 REF: 4
4. A relationship is an association between attributes.
ANS: F PTS: 1 REF: 5
5. A database will not only hold information about multiple types of entities, but also information
about the relationships among these multiple entities.
ANS: T PTS: 1 REF: 5
6. In a database, each entity has its own table.
ANS: T PTS: 1 REF: 5
, 7. The attributes of an entity become the rows in the table
ANS: F PTS: 1 REF: 5
8. In an entity-relationship (E-R) diagram, rectangles represent entities and lines represent
relationships between connected entities.
ANS: T PTS: 1 REF: 9
9. Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly,
rather than having to access it through the DBMS.
ANS: F PTS: 1 REF: 10
10. Sharing data is one advantage of database processing.
ANS: T PTS: 1 REF: 12
11. Eliminating redundancy is always possible when using a database approach.
ANS: F PTS: 1 REF: 13
12. A database cannot be password protected to prevent unauthorized users from accessing the data.
ANS: F PTS: 1 REF: 13
13. There is a greater impact of failure in a nondatabase, file-oriented system.
ANS: F PTS: 1 REF: 14
, 14. A good DBMS provides integrity constraints, which are features that let you change the structure
of the database without changing the programs that access the database.
ANS: F PTS: 1 REF: 14
15. To support all the complex functions that it provides to users, a DBMS must store data in
multiple files.
ANS: F PTS: 1 REF: 14
MULTIPLE CHOICE
1. Storing the same data in more than one place is called ____.
a. data independence c. redundancy
b. data integrity d. security
ANS: C PTS: 1 REF: 2
2. A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.
a. attribute c. entity
b. DBMS d. DBA
ANS: C PTS: 1 REF: 4
3. A(n) ____ is a characteristic or property of an entity.
a. attribute c. datapoint
b. constraint d. record
, ANS: A PTS: 1 REF: 4
4. A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet
or an accounting ledger.
a. spreadsheet c. data file
b. database d. attribute
ANS: C PTS: 1 REF: 5
5. The ____ of an entity become the columns in the database table.
a. E-R diagrams c. data files
b. tuples d. attributes
ANS: D PTS: 1 REF: 5
6. An association between entities is known as a(n) ____.
a. integrity constraint c. database
b. relationship d. data file
ANS: B PTS: 1 REF: 5
7. A visual way to represent a database is with a(n) ____.
a. spreadsheet c. DBA
b. DBMS d. entity-relationship diagram
ANS: D PTS: 1 REF: 9
TRUE/FALSE
1. Redundancy wastes space because you are storing the same data in more than one place.
ANS: T PTS: 1 REF: 2
2. A spreadsheet’s data-sharing features allows multiple employees to update data in one
spreadsheet at the same time.
ANS: F PTS: 1 REF: 2-3
3. An attribute is a characteristic or property of an entity.
ANS: T PTS: 1 REF: 4
4. A relationship is an association between attributes.
ANS: F PTS: 1 REF: 5
5. A database will not only hold information about multiple types of entities, but also information
about the relationships among these multiple entities.
ANS: T PTS: 1 REF: 5
6. In a database, each entity has its own table.
ANS: T PTS: 1 REF: 5
, 7. The attributes of an entity become the rows in the table
ANS: F PTS: 1 REF: 5
8. In an entity-relationship (E-R) diagram, rectangles represent entities and lines represent
relationships between connected entities.
ANS: T PTS: 1 REF: 9
9. Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly,
rather than having to access it through the DBMS.
ANS: F PTS: 1 REF: 10
10. Sharing data is one advantage of database processing.
ANS: T PTS: 1 REF: 12
11. Eliminating redundancy is always possible when using a database approach.
ANS: F PTS: 1 REF: 13
12. A database cannot be password protected to prevent unauthorized users from accessing the data.
ANS: F PTS: 1 REF: 13
13. There is a greater impact of failure in a nondatabase, file-oriented system.
ANS: F PTS: 1 REF: 14
, 14. A good DBMS provides integrity constraints, which are features that let you change the structure
of the database without changing the programs that access the database.
ANS: F PTS: 1 REF: 14
15. To support all the complex functions that it provides to users, a DBMS must store data in
multiple files.
ANS: F PTS: 1 REF: 14
MULTIPLE CHOICE
1. Storing the same data in more than one place is called ____.
a. data independence c. redundancy
b. data integrity d. security
ANS: C PTS: 1 REF: 2
2. A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.
a. attribute c. entity
b. DBMS d. DBA
ANS: C PTS: 1 REF: 4
3. A(n) ____ is a characteristic or property of an entity.
a. attribute c. datapoint
b. constraint d. record
, ANS: A PTS: 1 REF: 4
4. A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet
or an accounting ledger.
a. spreadsheet c. data file
b. database d. attribute
ANS: C PTS: 1 REF: 5
5. The ____ of an entity become the columns in the database table.
a. E-R diagrams c. data files
b. tuples d. attributes
ANS: D PTS: 1 REF: 5
6. An association between entities is known as a(n) ____.
a. integrity constraint c. database
b. relationship d. data file
ANS: B PTS: 1 REF: 5
7. A visual way to represent a database is with a(n) ____.
a. spreadsheet c. DBA
b. DBMS d. entity-relationship diagram
ANS: D PTS: 1 REF: 9
