mis ch 6

business intelligence
It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions.
historical data
Backward looking" budgets are typically based on
Responding to threats and opportunities and continuous planning is based on analyzing data from the ________ level of the organization.
Taking entities as tables, each row is a ________.
Taking entities as tables, each column is a(n) ________.
An attribute is also referred to as a(n) ________.
A(n) ________ is a collection of related attributes about a single instance of an entity.
database does not need to be changed if a change is made to an application
8) In DBMS, data are kept separate from the applications' programming code. This means that
entity-relationship diagram
A common way to represent a data model is a(n)
allocate storage space
Data type helps the DBMS
To finalize the data model in order to actually build the database, a process called ________ is used to make sure the database will operate efficiently.
eliminate data duplication
In DBMS, normalization helps to
data dictionary
Once the data model is created, the format of the data is documented in a(n)
metadata repository
A data dictionary is also known as
) Bringes' channel partners use a database system that supports the Oracle database system.
Bringes, a retail chain, has retail stores across three states. With its current legacy system, Bringes is having problems tracking the inventory levels for its stores. It is planning to implement Oracle database systems to replace this legacy system. Which of the following most supports Bringes' decision to replace its legacy system with an Oracle database system?
Treston's new database system was not supported by the database system of its suppliers and distributors.
Treston, an automobile manufacturer, has recently implemented a new database system. It is confident that this system will help enhance the company's internal (employees) and external (customers and channel partners) communication. Treston is planning to pursue a just-in-time inventory system soon after the database system is implemented. After the implementation of the database system, however, Treston realized that the database system was not effective. Which of the following, if true, can be cited as a reason for the failure of Treston's database system?
prevent illegal or illogical entries from entering the database
Business rules are captured by the designers of the database and included in the data dictionary to
are used to capture data to be added, modified, or deleted from the database
A(n) ________ is a compilation of data from the database that is organized and produced in printed format
retrieve information from a database
A query is used to
It helps to create a query quickly and easily.
Which of the following statements is true about query by example capabilities in a database?
operational systems
The systems that are used to interact with customers and run a business in real time are called
Master data
is the data that is deemed most important in the operation of a business
It consists of narrow and simple updates and queries.
Which of the following statements is true about an operational system?
ts goal is to enhance ease of access and use.
Which of the following statements is true about informational systems?
Data warehouse
integrates data from various operational systems.
put key business information into the hands of more decision makers
The purpose of a data warehouse is to
Data cleansing
refers to the process of standardizing the format of data retrieved from different systems.
data mart
A ________ is a data warehouse that is limited in scope.
It contains selected information from the data warehouse.
Which of the following statements is true about a data mart?
extract information from existing data
Information and knowledge discovery tools are used primarily to ________.
Scheduled reports
are produced at predefined intervals to support routine decisions.
They provide a summary of critical information on a recurring schedule.
Which of the following statements is true about key-indicator reports?
They provide a summary of critical information on a recurring schedule.
Which of the following statements is true about exception reports?
Drill-down reports
help analyze why a key indicator is not at an appropriate level or why an exception occurred.
They answer unplanned information requests to support a nonroutine decision.
Which of the following statements is true about ad hoc queries?
Online analytical processing
refers to the process of quickly conducting complex, multidimensional analyses of data stored in a database that is optimized for retrieval, typically using graphical software tools.
analyze different dimensions of data beyond simple data summaries
Online analytical processing tools enable users to ________.
It understands how data is organized in the database and has special functions for analyzing
the data.
Which of the following statements is true about online analytical processing server?
They preaggregate data so that only the subset of the data necessary for the queries is extracted.
How do online analytical processing systems improve performance?