Databases - Assignment (ALA) Assignment

Which of the following fields could be used as a primary key for a table? 1) Possible primary key 2) Ordinary field in the table

1) Possible primary key: * Social Security number * Voter registration number * Driver's license number 2) Ordinary field in the table: * Party affiliation * Last name * Street address * City

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

A) Company B) Manager C) Levels D) Hierarchy ✅

To search a database for information, create a ___.

A) form B) field C) query ✅ D) report

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

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

reports

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

A) 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. B) 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. C) A university system that uses students' reviews of its faculty and courses to help administrators make decisions about faculty members' salaries and tenure. D) 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. ✅

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.

A) Administration B) Organization C) Operating D) Management ✅

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.

A) 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. ✅ B) A nonprofit organization is interested in knowing the number of photos and blog posts other similar nonprofits include in their web page. C) 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. ✅ D) 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.

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?

A) Business intelligence software B) Data volume C) The cloud D) Big data ✅

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

A) Data Specificity B) Data Mart C) Data Configuration D) Data Type ✅

How are data marts different from data warehouses?

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

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

A) Data mining ✅ B) Business Intelligence C) Big data D) Data integrity

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

A) 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. ✅ B) 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. ✅ C) 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. D) 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.

Which statement best summarizes how organizations use data warehouses?

A) Data warehouses are used to regularly collect and store data from multiple sources. B) Data warehouses are used to store data from multiple sources for collective analysis. ✅ C) Data warehouses are used to combine and cross-check similar data from multiple sources. D) Data warehouses are used to grant access to data from multiple sources via a single entry point.

Which statement best summarizes how organizations use data warehouses?

A) Data warehouses are used to regularly collect and store data from multiple sources. B) Data warehouses are used to store data from multiple sources for collective analysis. ✅ C) Data warehouses are used to grant access to data from multiple sources via a single entry point. D) Data warehouses are used to combine and cross-check similar data from multiple sources.

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

A) Determining which departments or divisions of a company are profitable and which are losing money B) Evaluating the company's data infrastructure and integration to identify redundancies and cut costs C) Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain ✅ D) Comparing sales from previous years to help gauge the effectiveness of the marketing department

In the two tables in the image, which field is a foreign key?

A) FK OwnerID ✅ B) Pets C) Owners D) OwnerID

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

A) Infomart B) Database ✅ C) File cabinet D) Spreadsheet

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

A) Knowledge deployment B) Model building and evaluation ✅ C) Problem definition D) Data gathering and preparation

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.

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

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.

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

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

A) OwnerLastNames B) Pets ✅ C) Owners D) FK OwnerIDs

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

A) Primary Key B) Report C) Table ✅ D) Field

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

A) Professor B) Subject C) Classnumber ✅ D) Year

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

A) Top-down data marts are designed by department heads to serve specific functions. B) Dependent data marts extract data from a data warehouse when it is needed. ✅ C) Hybrid data marts combine data from a data warehouse and other collection systems. ✅ D) Independent data marts are separate from a data warehouse and are created in order to collect data relating only to particular business functions. ✅ E) Enterprise data marts combine data from related departments to create warehouses.

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?

A) Variety B) Veracity ✅ C) Velocity D) Volume

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?

A) Web content mining ✅ B) Web structure mining C) Web usage mining

Data mining is best described as ______.

A) a type of artificial intelligence (AI) program that uses statistics to automatically identify negative trends, likely outcomes, and corrective steps or actions to take B) 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 C) 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 ✅ D) the only means of mathematically analyzing data sets that are too large for online analytical processing (OLAP) software and simpler tools to handle

Organizations use data warehouses mainly to ______.

A) check the veracity of similar data from multiple sources B) provide a single gateway to data from multiple sources C) facilitate the analysis of data from multiple sources ✅ D) provide Internet security

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:

A) distribution B) setup C) hierarchy ✅ D) delivery

Businesses use business intelligence (BI) systems to ___.

A) ensure that their technologies, computer applications, and procedures are efficient B) collect and analyze information from multiple sources and analytic platforms C) create an accurate picture of their past, current, and future operations D) help them make decisions that are informed by business data and facts ✅

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

A) fields B) reports C) records D) queries ✅

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

A) link B) join C) partnership D) relationship ✅

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

A) predict which of a business' competitors may pose a serious threat B) help a business make strategic decisions based on its own data ✅ C) create a model of business operations using multiple data sources D) lower the cost of administration by automating routine operations

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

A) records B) reports ✅ C) tables D) forms

Where could you click to switch to Design view?

View

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ____ key.

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

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

system