BUS 311 CHAPTER 6

30 terms by mkkwak 

Create a new folder

Advertisement Upgrade to remove ads

Taking entities as tables, each row is a ________.

record

In database management system (DBMS), data are kept separate from the applications' programming code. This means that ________.

database does not need to be changed if a change is made to an application

common way to represent a data model is a(n) ________.

entity-relationship diagram

Data type helps the DBMS ________.

allocate storage space

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?

Bringes' channel partners use a database system that supports the Oracle database system.

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?

Treston's new database system was not supported by the database system of its suppliers and distributors.

Business rules are captured by the designers of the database and included in the data dictionary to ________.

prevent illegal or illogical entries from entering the database

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

Forms

A(n) ________ is a compilation of data from the database that is organized and produced in printed format.

report

A query is used to ________.

retrieve information from a database

true about query by example capabilities in a database?

It helps to create a query quickly and easily.

true about an operational system?

It consists of narrow and simple updates and queries.

________ integrates data from various operational system

Data warehouse

The purpose of a data warehouse is to ________.

key business information into the hands of more decision makers

________ is a data warehouse that is limited in scope.

data mart

true about a data mart?

It contains selected information from the data warehouse

Online analytical processing tools enable users to ________.

analyze different dimensions of data beyond simple data summaries

In online analytic processing systems, ________ are the values or numbers the user wants to analyze

measures

In online analytic processing systems, ________ provide a way to summarize the data.

dimensions

true about digital dashboards?

It supports usage models like push reporting, exception reporting and alerts, and pull reporting.

The structure of the data is typically captured in a query.

F

Structured Query Language (SQL) is the most common language used to interface with databases

T

Online analytical processing systems are designed for efficient retrieval of data and categorize data as measures and dimensions.

T

The development of a data warehouse is associated with the "ETL" process.

T

A data mart stores master data only.

F

In an ACCESS database, we create and use reports to add, modify or delete data from the database.

F

Online analytical processing (OLAP) analysis is used primarily for assessment purpose

T

RFM analysis is used primarily for prediction purpose.

F

When performing unsupervised data-mining, analysts develop a model prior to their analysis.

F

When performing data-mining using decision tree analysis, analysts use "if...then" decision rules in the decision process

T

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