Database Systems: Design, Implementation, and Management: Chapter 1
Review Questions
Study online at https://quizlet.com/_j5gmhl
1. 1. Define each Data: raw facts
of the following Field: an attribute, same data type
terms: Record: related data that describes an entity
a. data File: a collection of related records.
b. field
c. record
d. file
2. 2. What is data Data redundancy occurs when the same data are stored in multiple places unnec-
redundancy, and essarily.
which character-
istics of the file The use of spreadsheets and tables in different parts of the organization can cause
system can lead it.
to it?
3. 3. What is data in- Data independence exists when you can change the data storage characteristics
dependence, and without impeding the program's ability to access the data.
why is it lacking in
file systems?
4. 4. What is a DBMS = Database Management System
DBMS, and what
are its functions?
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
1/6
, Database Systems: Design, Implementation, and Management: Chapter 1
Review Questions
Study online at https://quizlet.com/_j5gmhl
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.
5. 5. What is struc- When it is possible to make changes in the file structure without affecting the
tural indepen- application program's ability to access the data.
dence, and why is
it important?
6. 6. Explain the dif- Data are raw facts that have not been processed. Information is data that has
ferences among been processed and given context. Databases help to facilitate the manipulation
data, informa- of data to create information by providing an organizational structure that makes
tion, and a data- relationships and connections between data explicit.
base.
7. 7. What is the role serves as the intermediary between the user and the database.
of a DBMS, and
what are its ad-
vantages? What
advantages:
are its disadvan-
tages?
improved data sharing
improved data security
better data integration
minimized data inconsistency
improved data access
improved decision making
2/6
Review Questions
Study online at https://quizlet.com/_j5gmhl
1. 1. Define each Data: raw facts
of the following Field: an attribute, same data type
terms: Record: related data that describes an entity
a. data File: a collection of related records.
b. field
c. record
d. file
2. 2. What is data Data redundancy occurs when the same data are stored in multiple places unnec-
redundancy, and essarily.
which character-
istics of the file The use of spreadsheets and tables in different parts of the organization can cause
system can lead it.
to it?
3. 3. What is data in- Data independence exists when you can change the data storage characteristics
dependence, and without impeding the program's ability to access the data.
why is it lacking in
file systems?
4. 4. What is a DBMS = Database Management System
DBMS, and what
are its functions?
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
1/6
, Database Systems: Design, Implementation, and Management: Chapter 1
Review Questions
Study online at https://quizlet.com/_j5gmhl
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.
5. 5. What is struc- When it is possible to make changes in the file structure without affecting the
tural indepen- application program's ability to access the data.
dence, and why is
it important?
6. 6. Explain the dif- Data are raw facts that have not been processed. Information is data that has
ferences among been processed and given context. Databases help to facilitate the manipulation
data, informa- of data to create information by providing an organizational structure that makes
tion, and a data- relationships and connections between data explicit.
base.
7. 7. What is the role serves as the intermediary between the user and the database.
of a DBMS, and
what are its ad-
vantages? What
advantages:
are its disadvan-
tages?
improved data sharing
improved data security
better data integration
minimized data inconsistency
improved data access
improved decision making
2/6
