MIS Chapter 6 Terms

physical database available for different logical views

A DBMS makes the

attribute

A characteristic or quality describing an entity is called a(n):

it 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

both historical and current data

A data warehouse is composed of:

library's card-catalog.

An example of a pre-digital database is a:

True

Common Gateway Interface is a specification for processing data on a Web server.

True

Each characteristic or quality describing a particular entity is called an attribute.

False

I n linking databases to the Web, the role of the application server is to host the DBMS.

data redundancy

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

creating an inventory of data definitions contained in the database

The data dictionary serves as an important data management tool by

presents data as they would be perceived by end users.

The logical view of a database

OLAP.

The tool that enables users to view the same data in different ways using multiple dimensions is

object-oriented DBMS

The type of database management approach that can handle multimedia is the

relational DBMS.

The type of logical database model that treats data as if they were stored in two-dimensional tables is the:

True

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

business intelligence

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as

False

A grouping of characters into a word, a group of words, or a complete number is called a record.

True

Data mining can be a challenge to individual privacy.

True

In normalization, complex groupings of data are streamlined to eliminate awkward many-to-many relationships.

DBMS for midrange computers.

Microsoft SQL Server is a(n):

False

A data warehouse is typically comprised of several smaller data marts.

True

A data warehouse may include information from legacy systems.

key field

A field identified in a record as holding the unique identifier for that record is called the

primary key.

A field identified in a table as holding the unique identifier of the table's records is called the:

True

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

with a crow's foot preceded by a short mark.

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

in two short marks.

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

entity-relationship diagram.

A schematic of the entire database that describes the relationships in a database is called a(n):

intersection relation.

A table that links two tables that have a many-to-many relationship is often called a(n)

DBMS for desktop systems

Access is a:

HTML

An alternative to using application server software for interfacing between a Web server and back-end databases is

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:

text mining

Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos

True

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

display data in an easier-to-read format

DBMS typically include report-generating tools in order to:

True

Data cleansing is the same process as data scrubbing.

find hidden relationships in data

Data mining is a tool for allowing users to

data scrubbing

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

True

Every record in a file should contain at least one key field.

False

Implementing a Web interface for a database requires changes to the database its

tuple.

In a relational database, a record is also called a(n):

select, project, and join

In a relational database, the three basic operations used to develop useful sets of data are

row

In a table for customers, the information about a single customer would reside in a single:

occurrences linked to a single event

In terms of the data relationships found by data mining, associations refers to

events linked over time

In terms of the data relationships found by data mining, sequences refers to

True

Many applications today require databases that can store and retrieve multimedia.

popular open-source DBMS.

MySQL is a

True

OLAP is a key tool of BI.

users to obtain online answers to ad hoc questions in a rapid amount of time.

OLAP is a tool for enabling

False

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to infer future behavior.

True

OODBMS are slower than relational DBMS.

False

One of the drawbacks to OODBMS is that they cannot work with applets.

DBMS for small handheld computing devices.

Oracle Database Lite is a

False

Predictive analysis is a technique of data mining.

combines relational tables to provide the user with more information than is otherwise available

The join operation

five tables: for customers, employees, suppliers, products, and sales.

The most basic business database is comprised of

SQL.

The most prominent data manipulation language today is:

normalization.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

creates a subset consisting of columns in a table

The project operation:

creates a subset consisting of all records in the file that meets stated criteria

The select operation:

data manipulation language.

The specialized language programmers use to add and change data in the database is called

Relationships between entities

What are the relationships that the relational database is named for?

I dentify the data needed to run the business

What is the first step you should take in managing data for a firm?

The entity CUSTOMER with the attribute ADDRESS

Which of the following best illustrates the relationship between entities and attributes?

OODBMS

Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

It is a quality-of-data concept that is used to identify a companyʹs most important data.

Which of the following is not a true statement about MDM?

Query wizard tool

Which of the following is not a typical feature of DBMS?

Data warehouse systems provide easy-to-use tools for managers to easily update data.

Which of the following statements about data warehouses is not true?

Web structure mining

Which of the following would you use to find out which Web sites with content related to database design were the most often linked to by other Web sites?

Web usage mining

Which of the following would you use to find patterns in user interaction data recorded by Web servers?