Unit 3 CIS

_________ grouping analysis reveals the relationship between variables along with the nature and frequency of the relationships.

Affinity

____________ expresses the specific number of instances in an entity.

Cardinality

_______ analysis is a technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible. Classification

Cluster

What is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks?

Data warehouse

What creates, reads, updates, and deletes data in a database while controlling access and security?

Database management system

______ data is erroneous or flawed data.

Dirty

___________, transformation, and loading is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.

Extraction

What is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse?

Extraction, transformation, and loading

Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information.

Information scrubbing and Information Cleansing

What is the overall process for developing information systems, from planning and analysis through implementation and maintenance?

Systems development life cycle

What reveals the relationship between variables along with the nature and frequency of the relationships?

affinity grouping analysis

A data _________ is a business analytics specialist who uses visual tools to help people understand complex data.

artist

What is the collection of data from various sources for the purpose of data processing?

data aggregation

A(n) entity-relationship __________ is a technique for documenting the entities and relationships in a database environment.

diagram

A(n) _________-to-many relationship is between two entities in which an instance of one entity is related to many instances of another and one instance of the other can be related to many instances of the first entity.

many

A data _______ contains a subset of data warehouse information.

mart

Data ________ is the process of analyzing data to extract information not offered by the raw data alone.

mining

What is a central location in which data is stored?

repository

A data ________ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. warehouse

warehouse