ISM 3011 Chapter 3 review

In the context of segmentation of customers in database marketing, _____ is a variable that includes gender, age, income, and marital status.

demographic information

A database administrator (DBA) is responsible for _____.

developing recovery procedures in case data is lost or corrupted

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

foreign key

A data _____ is the structure and organization of data, which involves fields, records, and files.

hierarchy

The data _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

manipulation

A data _____ is usually a smaller version of a data warehouse, used by a single department or function.

mart

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

predictive modeling

In a relational database, every record must be uniquely identified by a _____ key.

primary

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

AND operator

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

True

A _____ is software for creating, storing, maintaining, and accessing database files.

database management system

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

data dictionary

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

data model

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Database marketing

Labor and population statistics are examples of sources for internal data that are accessed by a database.

False

Static Web sites are useful for e-commerce sites that need frequent updates.

False

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Integrity rules

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Normalization

In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.

OR operator

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

True

In a relational database model, the columns are called _____.

attributes

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

create, read, update, and delete

Unlike data in databases, data in data warehouses is:

used for analytical purposes.

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

warehouse

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

why the buyer buys a product or service