ACC 409 CHAPTER 4 EXAM QUESTIONS AND ANSWERS WITH
COMPLETE SOLUTIONS GRADED A++
database
comprised of numerous entities about which the company wants to store data such as
customers, sales, and inventory.
record
Information about a single instance of an entity such as single customer is stored as
a ...
fields
The attributes of that record are specified as ...
database management system (DBMS)
the program that manages and controls the data and the interfaces between the data
and the application programs that use the data stored in the database
database system.
The database, the DBMS, and the application programs that access the database
through the DBMS
database administrator (DBA)
responsible for coordinating, controlling, and managing the database.
online transaction processing database (OLTP)
used to process normal business transactions.
data warehouse
, one or more very large databases containing both detailed and summarized data for a
number of years and from numerous sources used for analysis rather than transaction
processing. they complement OLTP by providing support for strategic decision making
business intelligence
analyzing large amounts of data for strategic decision making. There are two main
techniques.
Data mining
using sophisticated statistical analysis, including artificial intelligence techniques such
as neural networks, to "discover" unhypothesized relationships in the data. Credit card
companies use this to identify usage patterns indicative of fraud.
online analytical processing (OLAP)
using queries to investigate hypothesized relationships among data. A manager may
analyze supplier purchases for the last three years, followed by additional queries that
"drill down" to lower levels by grouping purchases by item number and by fiscal period.
Data integration
Previously separate application files are combined into large "pools" of data that many
application programs access. An example is an employee database that consolidates
payroll, personnel, and job skills files.
Data sharing
Integrated data are more easily shared with authorized users from centralized data
storage. Databases are easily browsed to research a problem or obtain detailed
information underlying a report. The FBI, which does a good job of collecting data but a
COMPLETE SOLUTIONS GRADED A++
database
comprised of numerous entities about which the company wants to store data such as
customers, sales, and inventory.
record
Information about a single instance of an entity such as single customer is stored as
a ...
fields
The attributes of that record are specified as ...
database management system (DBMS)
the program that manages and controls the data and the interfaces between the data
and the application programs that use the data stored in the database
database system.
The database, the DBMS, and the application programs that access the database
through the DBMS
database administrator (DBA)
responsible for coordinating, controlling, and managing the database.
online transaction processing database (OLTP)
used to process normal business transactions.
data warehouse
, one or more very large databases containing both detailed and summarized data for a
number of years and from numerous sources used for analysis rather than transaction
processing. they complement OLTP by providing support for strategic decision making
business intelligence
analyzing large amounts of data for strategic decision making. There are two main
techniques.
Data mining
using sophisticated statistical analysis, including artificial intelligence techniques such
as neural networks, to "discover" unhypothesized relationships in the data. Credit card
companies use this to identify usage patterns indicative of fraud.
online analytical processing (OLAP)
using queries to investigate hypothesized relationships among data. A manager may
analyze supplier purchases for the last three years, followed by additional queries that
"drill down" to lower levels by grouping purchases by item number and by fiscal period.
Data integration
Previously separate application files are combined into large "pools" of data that many
application programs access. An example is an employee database that consolidates
payroll, personnel, and job skills files.
Data sharing
Integrated data are more easily shared with authorized users from centralized data
storage. Databases are easily browsed to research a problem or obtain detailed
information underlying a report. The FBI, which does a good job of collecting data but a
