Database Systems 14th Edition Solutions & Answers Guide
| Coronel Morris ISBN 9780357673034
Ad Hoc Query - answers-A "spur-of-the-moment" query.
Analytical Database - answers-A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making.
Business Intelligence (BI) - answers-A comprehensive, cohesive, and integrated set of tools and
processes used to capture, collect, integrate, store, and analyze data with the purpose of
generating and presenting information to support business decision making.
Centralized Database - answers-A database located at a single site.
Cloud Database - answers-A database that is created and maintained using cloud services, such
as Microsoft Azure or Amazon AWS.
Data - answers-Raw facts, or facts that have not yet been processed to reveal their meaning to
the end user.
Data Anomoly - answers-A data abnormality in which inconsistent changes have been made to a
database. For example, and employee moves, but the address change is not corrected in all files
in the database.
Data Dictionary - answers-A DBMS component that stores metadata - data about data. Thus,
the data dictionary contains the data definition as well as their characteristics and relationships.
A data dictionary may also include data that are external to the DBMS. Also known as an
information resources dictionary.
1
, Data Inconsistency - answers-A condition in which different versions of the same data yield
different (inconsistent) results.
Data Independence - answers-A condition in which data access is unaffected by changes in the
physical data storage characteristics.
Data Integrity - answers-In a relational database, a condition in which the data in the database
complies with all entity and referential and integrity restraints.
Data Management - answers-A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletions, modification, and listing.
Data Processing (DP) Specialist - answers-The person responsible for developing and managing a
computerized file processing system.
Data Quality - answers-A comprehensive approach to ensuring the accuracy, validity, and
timeliness of data.
Data Redundancy - answers-Exists when the same data is stored unnecessarily at different
places.
Data Warehouse - answers-An integrated, subject-oriented, time-variant, nonvolatile collection
of data in a specialized database that stores historical and aggregated data in a format that
provides supports for decision making.
Database - answers-A shared, integrated computer structure that houses a collection of related
data. A database contains two types of data: end-user data (raw facts) and metadata.
2
| Coronel Morris ISBN 9780357673034
Ad Hoc Query - answers-A "spur-of-the-moment" query.
Analytical Database - answers-A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making.
Business Intelligence (BI) - answers-A comprehensive, cohesive, and integrated set of tools and
processes used to capture, collect, integrate, store, and analyze data with the purpose of
generating and presenting information to support business decision making.
Centralized Database - answers-A database located at a single site.
Cloud Database - answers-A database that is created and maintained using cloud services, such
as Microsoft Azure or Amazon AWS.
Data - answers-Raw facts, or facts that have not yet been processed to reveal their meaning to
the end user.
Data Anomoly - answers-A data abnormality in which inconsistent changes have been made to a
database. For example, and employee moves, but the address change is not corrected in all files
in the database.
Data Dictionary - answers-A DBMS component that stores metadata - data about data. Thus,
the data dictionary contains the data definition as well as their characteristics and relationships.
A data dictionary may also include data that are external to the DBMS. Also known as an
information resources dictionary.
1
, Data Inconsistency - answers-A condition in which different versions of the same data yield
different (inconsistent) results.
Data Independence - answers-A condition in which data access is unaffected by changes in the
physical data storage characteristics.
Data Integrity - answers-In a relational database, a condition in which the data in the database
complies with all entity and referential and integrity restraints.
Data Management - answers-A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletions, modification, and listing.
Data Processing (DP) Specialist - answers-The person responsible for developing and managing a
computerized file processing system.
Data Quality - answers-A comprehensive approach to ensuring the accuracy, validity, and
timeliness of data.
Data Redundancy - answers-Exists when the same data is stored unnecessarily at different
places.
Data Warehouse - answers-An integrated, subject-oriented, time-variant, nonvolatile collection
of data in a specialized database that stores historical and aggregated data in a format that
provides supports for decision making.
Database - answers-A shared, integrated computer structure that houses a collection of related
data. A database contains two types of data: end-user data (raw facts) and metadata.
2
