Databases

Select the advantages of using a database instead of a traditional filing system. Using a relational database, such as MS Access, is so easy that it requires no instruction A database can never be hacked A database can provide improved data integrity A database can hold larger amounts of data

A database can provide improved data integrity A database can hold larger amounts of data

The above database use common fields to create links between tables. This is called a ___ database. Multidimensional Object-Oriented Relational Linkage

Relational

The database above stores data in tables composed of rows (records) and columns (fields). Common fields link tables with relationships. This is called a: Combination Object-oriented Relational database Multidimensional

Relational database

Data mining is best described as ______. the process in which businesses create a strategy and action plan based on what their data mining software has identified, modeled, and predicted from their data 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 a type of artificial intelligence (AI) program that uses statistics to automatically identify negative trends, likely outcomes, and corrective steps or actions to take the only means of mathematically analyzing data sets that are too large for online analytical processing (OLAP) software and simpler tools to handle

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

Large databases, often called data banks, that cover particular subjects are referred to as _ databases.

commercial

Because it can store virtually unlimited amounts of data that can be shared across networks, and because the data can be kept far more accurately, a ----- has many advantages over a traditional filing system.

database

Organizations use data warehouses mainly to ______. provide Internet security provide a single gateway to data from multiple sources facilitate the analysis of data from multiple sources check the veracity of similar data from multiple sources

facilitate the analysis of data from multiple sources

In the datasheet view of a relational database, a column is called a ___

field

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.

forms

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: delivery hierarchy setup distribution

hierarchy

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 The cloud Data volume Business intelligence software

Big data

What is a foriegn key?

The foreign key is a field that is used to link to related tables.

A collection of related records in a database is referred to as a _____. Primary Key Table Report Field

Table

Where could you click to switch to Design view?

View

A link between tables in a relational database that defines how the data are related is called a _____. relationship link join partnership

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 records forms tables

reports

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. A regional sporting goods chain that uses customers' billing and shipping information and order history to mail them catalogs and postcards for sales and promotions. A popular food truck that regularly tweets and posts its location, offers coupon codes to its followers on social media, and accepts mobile, digital wallet payment. A university system that uses students' reviews of its faculty and courses to help administrators make decisions about faculty members' salaries and tenure.

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.

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

Data Type

ow are data marts different from data warehouses? Data marts contribute to an organization's data warehouse by supplying the data from one department or function. Data marts focus on an individual department or business function and manage less data than a data warehouse. Data marts combine data from an organization's data warehouse with new data obtained from other sources. Data marts are stand-alone, departmental data systems, while data warehouses are an integrated, enterprise-level system.

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 integrity Big data Business Intelligence Data mining

Data mining

Which statement best summarizes how organizations use data warehouses? Data warehouses are used to grant access to data from multiple sources via a single entry point. Data warehouses are used to regularly collect and store data from multiple sources. Data warehouses are used to store data from multiple sources for collective analysis. Data warehouses are used to combine and cross-check similar data from multiple sources.

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

A collection of related data that can be sorted, logically organized, searched, and stored is called a: Processor Database Spreadsheet Presentation

Database

A database that stores data in different physical locations and that users access though client/server networks is called a ___ database. Joint-use Structured Commercial Distributed

Distributed

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 ___. Company Manager Hierarchy Levels

Hierarchy

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

You own a pet care center. Which three fields you might enter when you create a table for the dogs that you care for? Owner's phone number Pet's name Owner's driver's license number Owner's last name

Owner's phone number Pet's name Owner's last name

Which three of the following statements are about database fields? A field is a row in a table. Primary key is a field designation. Represents a characteristic of someone or something A group of related characters in a database table

Primary key is a field designation. Represents a characteristic of someone or something A group of related characters in a database table

For which task is a data mart more useful or appropriate than a data warehouse? Determining which departments or divisions of a company are profitable and which are losing money Comparing sales from previous years to help gauge the effectiveness of the marketing department Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain Evaluating the company's data infrastructure and integration to identify redundancies and cut costs

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

Which of the following statements correctly describes a defining characteristic of Big Data? More than one answer may be correct. The data are measured in terabytes (trillions of bytes) or even larger units. The data are accurate and have been verified across multiple, separate sources. The data are automatically collected and processed or analyzed at least once daily. 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. The data are from structured and unstructured sources and exist in multiple forms.

The primary key field will have a unique entry for each record

The primary key field will have a unique entry for each record

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 structure mining Web content mining Web usage mining

Web content mining

Businesses use business intelligence (BI) systems to ___. create an accurate picture of their past, current, and future operations collect and analyze information from multiple sources and analytic platforms help them make decisions that are informed by business data and facts ensure that their technologies, computer applications, and procedures are efficient

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

The reliability and the accuracy of the information in a database is referred to as data ____

integrity

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

queries

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ____

record

In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ . list table field record

record

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

system

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. How much a 23-year-old male college student will spend on a new car after starting his first job

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.

Katrina was a senior in college when she married her high school sweetheart. She changed her last name, and because the college used a centralized database, each of her instructors had her new name in their gradebooks. This is an example of how centralization can improve data: correctness integrity accuracy reliability

integrity

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. Target keeps track of how many shoppers visit their stores on Sundays. 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. DropBox tracks how many people subscribe to their services after viewing a specific marketing e-mail. Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues.

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.

Which of the following correctly describes a type of data mart? More than one answer may be correct. Dependent data marts extract data from a data warehouse when it is needed. Independent data marts are separate from a data warehouse and are created in order to collect data relating only to particular business functions. Enterprise data marts combine data from related departments to create warehouses. Hybrid data marts combine data from a data warehouse and other collection systems. Top-down data marts are designed by department heads to serve specific functions.

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

A leading manufacturer of fitness trackers partners with a large health insurance network. Insurance network members receive a discounted fitness tracker and financial rewards for setting and achieving tracked personal fitness goals. Which characteristic of the resulting Big Data would be most directly affected by a tracker software error that counted users' arm movements as steps? Variety Veracity Velocity Volume

Veracity

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

Select all that apply Which of the following is an example of why a database should be A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. A large company is in the beginning stages of a new product that it anticipates will completely change their market. At this point of development, the company wants only a very limited number of employees have access to information regarding this product. A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database. A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative.

A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database. A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative.

What term describes the process organizations use to discover meaningful relationships and patterns among the data sets it has collected? Multiple choice question. Data integrity Business Intelligence Data mining Big data

Data mining

Which of the following would be a reason why an organization would use web usage mining? More than one answer may be correct. 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. 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 local retailer is looking to increase their online sales and wants to know the types of pages and links a local competitor includes on their website. A nonprofit organization is interested in knowing the number of photos and blog posts other similar nonprofits include in their web page.

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. 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.

Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS). Multiple select question. 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. Data warehouses are used to create valuable collections of data that organizations can sell to others, because the profits help fund the organization's enterprise-level, strategic goals. 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 marts are used to compare specific data from different departments or business functions, because the data mart for each area contains more detailed data than a data warehouse.

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. 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.

Which of the following is an example of an advantage of being able to access a database via the web? More than one answer may be correct. Your product is primarily sold in developing countries where most of your suppliers are small business owners who access the Internet via a mobile device instead of a computer. Your company needs suppliers in all countries to be able to access your inventory database. Turnover among telephone customer service representatives at your company is high and they receive only brief training before they interact with customers. Reps need to be able to access your sales database to assist customers who call. A company wants to ensure that the data it keeps on its database are secure and cannot be accessed by unauthorized users.

Your product is primarily sold in developing countries where most of your suppliers are small business owners who access the Internet via a mobile device instead of a computer. Your company needs suppliers in all countries to be able to access your inventory database. Turnover among telephone customer service representatives at your company is high and they receive only brief training before they interact with customers. Reps need to be able to access your sales database to assist customers who call.

ndividual database matches Choice, A combined set of data files. Intended for use by one person A combined set of data files. Intended for use by one person Company database matches Choice, Users access the organizations database through a LAN Users access the organizations database through a LAN Distributed database matches Choice, Data is stored in different physical locations - accessed through a client/server network Data is stored in different physical locations - accessed through a client/server network Commercial database matches Choice, Often referred to as a data bank Often referred to as a data bank

ndividual database matches Choice, A combined set of data files. Intended for use by one person A combined set of data files. Intended for use by one person Company database matches Choice, Users access the organizations database through a LAN Users access the organizations database through a LAN Distributed database matches Choice, Data is stored in different physical locations - accessed through a client/server network Data is stored in different physical locations - accessed through a client/server network Commercial database matches Choice, Often referred to as a data bank Often referred to as a data bank