Database Systems: Design, Implementation, and
Management: Chapter 1 Review Questions (Correctly
solved)
1. Define each of the following terms:
a. data
b. field
c. record
d. file correct answers Data: raw facts
Field: an attribute, same data type
Record: related data that describes an entity
File: a collection of related records.
2. What is data redundancy, and which characteristics of the file system can lead to it? correct
answers Data redundancy occurs when the same data are stored in multiple places unnecessarily.
The use of spreadsheets and tables in different parts of the organization can cause it.
3. What is data independence, and why is it lacking in file systems? correct answers Data
independence exists when you can change the data storage characteristics without impeding the
program's ability to access the data.
4. What is a DBMS, and what are its functions? correct answers DBMS = Database
Management System
a collection of programs that manages the database structure and controls access to the data
stored in the database. (think electronic filing cabinet)
functions of a DBMS:
data dictionary management
data storage management
data transformation and presentation
security management
multi user access control
backup and recovery management
data integrity management
database access languages and application programming interfaces.
database communication interfaces.
Management: Chapter 1 Review Questions (Correctly
solved)
1. Define each of the following terms:
a. data
b. field
c. record
d. file correct answers Data: raw facts
Field: an attribute, same data type
Record: related data that describes an entity
File: a collection of related records.
2. What is data redundancy, and which characteristics of the file system can lead to it? correct
answers Data redundancy occurs when the same data are stored in multiple places unnecessarily.
The use of spreadsheets and tables in different parts of the organization can cause it.
3. What is data independence, and why is it lacking in file systems? correct answers Data
independence exists when you can change the data storage characteristics without impeding the
program's ability to access the data.
4. What is a DBMS, and what are its functions? correct answers DBMS = Database
Management System
a collection of programs that manages the database structure and controls access to the data
stored in the database. (think electronic filing cabinet)
functions of a DBMS:
data dictionary management
data storage management
data transformation and presentation
security management
multi user access control
backup and recovery management
data integrity management
database access languages and application programming interfaces.
database communication interfaces.
