Mis 309 Chapter 6

Front 1

maintains information about various types of objects, events, people, and places

Back 1

Database

Front 2

a system that allows users to create, read, update, and delete data in a relational database

Back 2

Database Management systems (DBMS)

Front 3

smallest unit of information

Back 3

Data element

Front 4

logical data structure that details the relationships among data elements using graphics or pictures

Back 4

Data model

Front 5

details about data

Back 5

Metadata

Front 6

compiles all metadata in a data model

Back 6

Data dictionary

Front 7

inability to track customers, identify selling opportunities, build customer relationships are all examples of the consequences of what kind of information

Back 7

Low quality information

Front 8

person, place, thing, transaction, or event about which information is stored

Back 8

Entity

Front 9

fields or columns - the characteristics of the entity class

Back 9

Attributes

Front 10

field, or group of fields, that uniquely identifies each entity

Back 10

Primary Key

Front 11

a primary key in one table that appears as an attribute in another table, providing a relationship between the two tables

Back 11

Foreign key

Front 12

this view of information deals with the physical storage of information on a device, such as a hard disk

Back 12

Physical view

Front 13

increased flexibility, increased scalability and performance, reduced information redundancy, are examples of advantages of what

Back 13

Databases

Front 14

this view of information deals with how users logically access information to meet their particular needs

Back 14

Logical view

Front 15

how well a system can adapt to increased demands

Back 15

Scalability

Front 16

how quickly a system can perform a certain process

Back 16

Performance

Front 17

the duplication of information

Back 17

Redundancy

Front 18

measure of quality of information

Back 18

Information integrity

Front 19

rules that help ensure the quality of information, can be defined and built into the database design; two types: relational and business-critical

Back 19

Integrity constraints

Front 20

rules that enforce basic and fundamental information based constraints, such as not allowing someone to create an order for a nonexistent customer, or order zero pounds of materials

Back 20

Relational integrity constraints

Front 21

rules that enforce business rules vital to an organizations success, such as a limit on product returns

Back 21

Business-critical integrity constraints

Front 22

software through which users and application prorams interact with a database, either directly or indirectly

Back 22

Database Management Systems (DBMS)

Front 23

this allows separate systems to communicate directly with each other

Back 23

Integration

Front 24

takes information entered into a given system and sends it automatically to all downstream systems and processes

Back 24

Forward integration

Front 25

takes information entered into a given system and sends it automatically to all upstream systems and processes

Back 25

Backward integration

Front 26

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

Back 26

Data warehouse

Front 27

the primary purpose of a _____ ________ is to aggregate information throughout an organization into a single repository for decision-making purposes

Back 27

Data warehouse

Front 28

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

Back 28

(ETL) - Extraction, Transformation, Loading

Front 29

this contains a subset of data warehouse information; the access layer of the data warehouse environment that is used to get data out to the users

Back 29

Data mart

Front 30

this determines who has access to different types of information

Back 30

Access level

Front 31

determines the types of user access, such as read-only access

Back 31

Access control

Front 32

an interactive website kept constantly updated

Back 32

Data-driven website

Front 33

easy to manage content, easy to store large amounts of data, easy to eliminate human errors. These are all advantages of what kind of website?

Back 33

Data-driven website

Front 34

a particular attribute of information

Back 34

Dimension

Front 35

a term for the representation of multidimensional information

Back 35

Cube

Front 36

True or False:
Databases contain information in a series of two-dimensional tables.

Back 36

True

Front 37

this is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information

Back 37

Information cleansing or scrubbing

Front 38

the collection of information into a more useful form, such as totals, averages, summaries, etc.

Back 38

Aggregation

Front 39

True or False:
A data warehouse aggregates information from various databases into a more useful form so that employees can make decisions and make analyses of the information.

Back 39

True

Front 40

True or False:
A database is multidimensional, containing many layers of columns and rows of information.

Back 40

False. This is the definition of a data warehouse and related data marts.

Front 41

the process of analyzing data to extract information not offered by raw data alone

Back 41

Data mining

Front 42

All of the following are data mining tools except for:
a. Classification
b. Analysis
c. Estimation
d. Affinity grouping
e. Clustering

Back 42

b. Analysis.

Analysis is NOT a data mining tool. A data mining tool is used to find patterns and relationships in large volumes of information; the ultimate purpose of data mining is analysis, thus analysis cannot be a tool for analysis.

Front 43

True or False:
Structured data is data that does not exist in a fixed location and can include text documents, PDFs, voice messages, or emails

Back 43

False. This is the definition of unstructured data.

Front 44

All of the following are common forms of data mining analysis capabilities except:
a. Cluster analysis
b. Association detection
c. Classification tools
d. Statistical analysis

Back 44

c. Classification tools is not a form of data mining analysis capabilities. I made it up.

Front 45

This is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and different groups are as far apart as possible. This is a common form of data mining analysis.

Back 45

Cluster analysis

Front 46

this common technique for data mining analysis reveals the relationship between variables along with the nature and frequency of the relationships.

Back 46

Association detection

Front 47

an analysis used by retailers seeking to understand the purchase behavior of customers.

Back 47

Market basket analysis

Front 48

the rule that a customer who buys onions and tomatoes is also likely to purchase hamburgers is an example of which data mining tool?

Back 48

Association detection (also called affinity analysis)

Front 49

this type of data mining analyzes unstructured data to find trends and patterns in words and sentences

Back 49

Text mining

Front 50

this type of data mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation

Back 50

Web mining

Front 51

this type of data mining analysis finds correlations, distributions, calculations, and variance analysis

Back 51

Statistical analysis

Front 52

predictions made on the bases of time-series information

Back 52

Forecast

Front 53

time stamped information collected at a particular frequency

Back 53

Time-series information

Front 54

True or False:
Business intelligence helps businesses improve the quality of business decisions.

Back 54

True.

Front 55

True or False:
Business intelligence only affects business decisions. It has no affect on costs and revenues.

Back 55

False. Business intelligence affects both business decisions and costs and revenues.

Business intelligence helps businesses have access to reliable, consistent, understandable, and easily manipulated data.

Front 56

in this kind of database model, information is organized into a tree-like structure that allows repeating information using parent/child relationships in such a way that it cannot have too many relationships. These used to be widely used in the past, but not so much these days.

Back 56

Hierarchical database model

Front 57

this type of database model is a flexible way of representing objects and their relationships. This model allows each record to have multiple "parent" and "child" records.

Back 57

Network database model

Front 58

Which of the following represents the different information levels?
a. Individual, department, enterprise
b. Detail, summary, aggregate
c. Document, presentation, spreadsheet, database
d. All of the above

Back 58

a. Individual, department, enterprise

Front 59

What in the relational database model is a person, place, thing, transaction, or event about which information is stored?
a. Attribute
b. Primary key
c. Entity
d. Foreign key

Back 59

c. Entity

Front 60

All of the following are advantages of database-stored information, except:
a. Reduced information redundancy
b. Increased scalability and performance
c. Reduced information integrity
d. Increased flexibility

Back 60

c. Reduced information integrity.

Database-stored information increases information integrity.

Front 61

What is the duplication of data, or the storage of the same data in multiple places?
a. Data redundancy
b. Information integrity
c. Scalability
d. Performance

Back 61

a. Data redundancy

Front 62

What are the rules that help ensure the quality of information?

a. Relational integrity constraints
b. Information integrity
c. Integrity constraints
d. Business-critical integrity constraints

Back 62

c. Integrity constraints

Front 63

Which of the following describes ETL?

a. A process that transforms information using a common set of enterprise definitions
b. A process that loads information into a data warehouse
c. A process that extracts information from internal and external databases
d. All of the above

Back 63

D. all of the above describe ETL, which is a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse

(ETL) - Extraction, Transformation, Loading

Front 64

What is data mining?

a. A particular attribute of information
b. The common term for the representation of multidimensional information
c. The process of analyzing data to extract information not offered by the raw data alone.
d. Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.

Back 64

c. The process of analyzing data to extract information not offered by the raw data alone.