30 terms


select, project, and join.
In a relational database, the three basic operations used to develop useful sets of data are
OLAP is a key tool of BI.
Identifying sequences
You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of
airport code
You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?
An alternative to using application server software for interfacing between a Web server and back-end databases is
You work for an national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of
in a table for customers, the information about a single customer would reside in a single
Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.
key field
A field identified in a record as holding the unique identifier for that record is called the
The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.
data manipulation language
The specialized language programmers use to add and change data in the database is called
Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.
In a Web-based database, middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.
Microsoft access
DBMS for midrange computers include all of the following EXCEPT
Predictive analysis is synonymous with data mining.
OODBMS are slower than relational DBMS.
creates a subset consisting of all records in the file that meet stated criteria.
The select operation
Each characteristic or quality describing a particular entity is called an attribute.
In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.
data dictionary
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the
combines relational tables to provide the user with more information than is otherwise available.
The join operation
The tool that enables users to view the same data in different ways using multiple dimensions is
user mining
Which of the following is not one of the techniques used in Web mining?
In a relational database, a record is referred to in technical terms as a(n)
Every record in a file should contain at least one key field.
A DBMS separates the logical and physical views of data.
a data mart typically focuses on a single subject area or line of business.
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because
display data in an easier-to-read format.
DBMSs typically include report-generating tools in order to
the entity CUSTOMER with the attribute PURCHASE
Which of the following best illustrates the relationship between entities and attributes?
A data warehouse is typically comprised of several smaller data marts.