Upgrade to remove ads
Only $35.99/year

Chapter 6 quiz

Terms in this set (20)

A database
maintains information about various types of objects, events, people, and places.
primary key
a field (or group of fields) that uniquely identifies a given entity in a table
Prediction
is a statement about what will happen or might happen in the future, for example, estimating future sales or employee turnover.
analyze popular vacation locations with current flight listings
How would the airline industry use business intelligence?
Infographics
can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.
A database can support many logical views.
Which of the following is correct in reference to a database?
Advanced analytics
focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
veracity
In terms of big data, what includes the uncertainty of data, including biases, noise, and abnormalities?
static information
includes fixed data incapable of change in the event of a user action
Structured query language
asks users to write lines of code to answer questions against a database.
relational
integrity constraint does not allow someone to create an order for a nonexistent customer.
data marts
ultimate outcome of a data warehouse
relational database management system
Which of the following systems allow users to create, read, update, and delete data in a relational database?
extraction, transformation, and loading
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
data-driven website
is an interactive website kept constantly updated and relevant to the needs of its customers using a database.
Web analytics
analyzes unstructured data associated with websites to identify consumer behavior and website navigation.
predict hardware failures
How would the technology industry use business intelligence?
Structured data
has a defined length, type, and format and includes numbers, dates, or strings such as customer address.
Classification
is a form of data mining that assigns records to one of a predefined set of classes.
master data management
What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?
Sets with similar terms