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