mis ch 6

40 terms by haleypeterson 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

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

operational

Responding to threats and opportunities and continuous planning is based on analyzing data from the ________ level of the organization.

record

Taking entities as tables, each row is a ________.

attribute

Taking entities as tables, each column is a(n) ________.

field

An attribute is also referred to as a(n) ________.

record

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

normalization

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

forms

are used to capture data to be added, modified, or deleted from the database

report

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?

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set