Part 3 - Databases

In analyzing transactions, Walmart discovered that many people who buy Children's Tylenol in their stores also buy orange juice in the same transaction. They used this information to discount Children's Tylenol but raise the price of orange juice during flu season. What is the name of the approach Walmart used to discover this information?

Big data

In the ClassList table, the primary key is likely the __ field.

Classnumber

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ___.

Database

Which of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?

Model building and evaluation

A collection of related records in a database is referred to as a _____.

Table

Data mining is best described as ______.

a research and analysis technique in which data analysts employ mathematical tools and artificial intelligence (AI) to search large volumes of data and discover less-obvious patterns and trends

You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In StubHub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ______.

database

The primary purpose of a business intelligence (BI) system is to ______.

help a business make strategic decisions based on its own data

A link between tables in a relational database that defines how the data are related is called a ______

relationship

Forms allow data to go into a database, ___ display information coming out of a database.

reports

To display or distribute information from a database, programmers or database administrators create ___.

reports

Possible primary key

social security numbers driver's license numbers voter registration number

Where could you click to switch to Design view?

view

Given the Four V's of Big Data, which of the following organizations most likely uses Big Data?

A leading news website that uses data about its visitors' and followers' activities to shape its news coverage, customize news alerts, and gain advertisers and subscribers.

Select all that apply Which of the following would be a reason why an organization would use web usage mining? More than one answer may be correct.

An e-commerce business looking to improve the customer experience on its website to boost sales wants to know what types of sites users go to after visiting their website and putting items in their cart, but not completing a purchase. A new social media platform wants to increase engagement and is looking to know what content its most frequent users spend the most time engaging with.

Select all that apply Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings? More than one answer may be correct.

An in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for falling in their homes. Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues.

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

Select all that apply Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS).

Data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area. Data warehouses are used to analyze long-term, historical data for an organization's strategic purposes, because they store data from different time periods and subject areas.

How are data marts different from data warehouses?

Data marts focus on an individual department or business function and manage less data than a data warehouse.

What term describes the process organizations use to discover meaningful relationships and patterns among the data sets it has collected?

Data mining

Which statement best summarizes how organizations use data warehouses?

Data warehouses are used to store data from multiple sources for collective analysis.

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ________.

Hierarchy

Select all that apply Which of the following correctly describes a type of data mart? More than one answer may be correct.

Independent data marts are separate from a data warehouse and are created in order to collect data relating only to particular business functions. Dependent data marts extract data from a data warehouse when it is needed. Hybrid data marts combine data from a data warehouse and other collection systems.

Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries, and other capabilities, it is often referred to as a Database ___ System.

Management

In the relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many relationship. This means that each entry in the OwnerID field can be linked to many _____.

Pets

For which task is a data mart more useful or appropriate than a data warehouse?

Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain

Select all that apply Your college has a database with a Students table. Which of the following could be a primary key in the table?

Student number Social Security Number

A DBMS maximizes the benefits a database can provide. DBMS stands for Database Management _________.

System

Select all that apply Which of the following statements correctly describes a defining characteristic of Big Data? More than one answer may be correct.

The data are from structured and unstructured sources and exist in multiple forms. The data are measured in terabytes (trillions of bytes) or even larger units.

Select all that apply Which of the following is an example of the type of information data mining can yield? More than one answer may be correct.

The likelihood of a Gen-X female who makes $50,000 and is divorced with no children will take a trip within a year of her divorce being finalized Middle-aged males who are members of their local church bible study group are more inclined to vote than younger males who are also members of local bible study groups.

A corporate sales organization is hosting its annual regional meeting. It needs to book a hotel within the region where attendees will stay for three days and two nights. The hotel must have: 30 standard hotel rooms for its sales reps, 5 suites for the regional managers, and 5 conference rooms to hold training sessions. There also must be two restaurants within walking distance of the hotel that can accommodate a dinner reservation for 40 people. Which web mining technique would the organization use to narrow down the choices of hotels to those that fit these parameters?

Web content mining

Organizations use data warehouses mainly to ______.

facilitate the analysis of data from multiple sources

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a .

foreign

To create a relationship between two tables, it is necessary to create a _________ key in one table that is the primary key of the other table.

foreign

When you need to link two tables in a database that do not have a field in common, one solution is to create a ______.

foreign key

Businesses use business intelligence (BI) systems to ___.

help them make decisions that are informed by business data and facts

Businesses use business intelligence (BI) systems to ______.

help them make decisions that are informed by business data and facts

The order in which data is organized in a database (characters, fields, records, tables, files, databases) is referred to the database _________.

hierarchy

When programmers design a database, they start by determining what data or characters will be entered. Next, they decide what fields would best organize these data. With this, records and tables can be created, eventually building an entire database. This organization is called the database:

hierarchy

So that users can find specific information quickly by using filters based on specific criteria, databases allow the creation of ___.

queries

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ______.

query

Ordinary field in the table

street address last name city party affiliation