Database

When building a database, careful consideration must be given to the logical structure by asking ___________.

"How is the data to be arranged so that it makes sense to users?"

________ is one of the smaller database development platforms available for use by individuals as well as small businesses and organizations.

Microsoft Access

The business use of data mining—often called ____, a term first coined by a consultant at Gartner Group—can help increase efficiency, reduce costs, or increase profits.

business intelligence or BI

_____________ ecommerce uses the web to connect individuals who wish to sell to other individuals.

c2c

_______ refers to the process of extracting information from a data warehouse or data mart.

data mining

A(n) ______ is a generalized class of people, places, or things (objects) for which data is collected, stored, and maintained.

entity

_______ reports are automatically produced when a situation is unusual or requires action.

exception

A collection of related fields that describe some object or activity is a file.

false

Management systems depend on databases for daily operations and strategic planning.

false

Only individuals shop online, not businesses.

false

Personal information management (PIM) software such as Google Calendar utilizes a general- purpose database.

false

Primary keys ensure that duplicate records are not stored in a database.

false

Behavioral targeting is a marketing practice that involves collecting information about consumer behavior in order to improve marketing and advertising directed at _______ consumer interests.

individual

In DBMS terms, combining two or more tables is a process called ____.

joining

A(n) _______ report, a special type of scheduled report, summarizes the previous day's critical activities and is typically available at the beginning of each workday.

key indicator

_______ is currently the market leader in general-purpose databases.

oracle

________ keys are essential for the functioning of a database management system.

primary

The ability to connect data in different tables through a common field is sometimes referred to as a(n) _______.

relationship

Database ____ refers to the manner in which data is organized and stored.

structure

A collection of related records is a _____, also called a ____ in some databases.

table, file

If an artist has recorded the same song on multiple albums, it would be necessary to combine ____ as a primary key.

track title, album title and artist

A database should be designed to store all data relevant to the organization, and provide quick access and easy modification.

true

A flat file database stores database records in a plain text file.

true

B2C ecommerce is sometimes called etail, a takeoff on the term "retail," as it is the online equivalent of a brick-and-mortar retail store.

true

Conducting business online offers convenience and savings to both buyers and sellers.

true

Credit reports are used to evaluate the financial reliability of borrowers.

true

Data mining is used by government agencies to detect patterns of terrorist activity.

true

Database syntax typically requires that field names not include any spaces.

true

Every field has a field name and can have either a fixed or a variable length.

true

MIS reports present useful information for management, often compiled by sorting a database.

true

Once data has been placed into a relational database, data inquiries and manipulations can be made using a DBMS.

true

Records are an important element of the database hierarchy because they are used to store the database entities.

true

Scheduled reports are produced periodically or on a schedule, such as daily, weekly, or monthly.

true

The DBMS can be used to generate a variety of reports that help people and organizations make decisions and achieve their goals.

true

The Web itself could be viewed as the world's largest database management system.

true

The business-intelligence approach was first used by General Mills in 1977 to analyze data from checkout scanners.

true

The larger a database, the more time is required to define the relationships between the data and its underlying structure.

true

The object-relational model encapsulates data and database functionality together in software objects.

true

The primary key distinguishes records so that they can be accessed, organized, and manipulated.

true

The structure of the relationships in most databases follows a logical model.

true