How can we help?

You can also find more resources in our Help Center.

30 terms

MIS

STUDY
PLAY
select, project, and join.
In a relational database, the three basic operations used to develop useful sets of data are
True
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?
CGI
An alternative to using application server software for interfacing between a Web server and back-end databases is
classification
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
row
in a table for customers, the information about a single customer would reside in a single
True
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
False
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
true
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.
True
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
false
Predictive analysis is synonymous with data mining.
true
OODBMS are slower than relational DBMS.
creates a subset consisting of all records in the file that meet stated criteria.
The select operation
true
Each characteristic or quality describing a particular entity is called an attribute.
True
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
OLAP
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?
tuple
In a relational database, a record is referred to in technical terms as a(n)
true
Every record in a file should contain at least one key field.
true
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?
False
A data warehouse is typically comprised of several smaller data marts.