MISY_3310 Ch 2 - Databases

Which statement explains the difference between a database and a database management system (DBMS)?

A DBMS is a software program designed to organize and administer databases.

What is the purpose of an SQL statement?

Answer questions about the database

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.

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

Database management system (DBMS) make it easier to secure data and information because they ______.

allow for the creation of access constraints

Businesses use business intelligence (BI) systems to ___.

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

Forms structure data input to help ensure data , meaning the information entered is accurate, timely, and useful.

integrity or accuracy

To search a database for information, create a ___.

query

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

record

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

Classnumber

Select all that apply Which of the following statements correctly describes referential integrity? More than one answer may be correct.

For referential integrity to exist, data on both sides of the table relationship must be present. Referential integrity applies to data quality within the structure of a relational database.

Why is it important for all organizations, no matter how small, to create and implement organizational information policies?

Organizational data are a critical asset; it is important to ensure its security.

Which statement best summarizes how a data governance (DG) plan is created?

The plan is tailored to the organization's specific goals, objectives, and activities.

Data integrity is increased when ______.

data are centralized

The practice of data scrubbing is a vital part of data quality management because it ______.

ensures ongoing data validity by identifying and then fixing data errors

A relational database management system (RDBMS) is a type of DBMS whose primary function is to ______.

show how data are connected through relationships

The primary characteristic of a relational database is that it ______.

stores and allows access to data objects that are related to one another

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 are advantages of cloud databases over a traditional database? More than one answer may be correct.

Can be accessed through an application programming interface (API) Are maintained by an external provider, such as Amazon or Oracle Can support both SQL and NoSQL databases

Which type of database maintains the hardware and operating system offsite and is accessed via Internet-based applications?

Cloud database

Which statement most accurately describes the value of data integrity to an organization?

Databases and database management system (DBMS) with a high level of data integrity enable more efficient data maintenance in support of organizational goals.

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

Model building and evaluation

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.

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.

Select all that apply Which of the following tasks can businesses perform with the help of in-memory computing? More than one answer may be correct.

Predicting the impact of news on stock prices and conducting immediate transactions Mapping alternate driving routes to help truckers avoid bad weather and traffic jams Alerting online customers that the desired item is out of stock, before the order is placed

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

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

FK OwnerID

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

Select all that apply From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.

The employees who report to a specific manager in an organizational chart The courses a student is taking Products a customer has ordered

The four steps in a data quality audit are ______.

assessment, design, transformation, and monitoring

Organizations often use data scrubbing software because it ______.

automatically analyzes data, then fixes any errors, and consistently formats the data according to an organization's guidelines

Businesses can use in-memory computing to conduct or support almost any task that ______.

involves the near-instantaneous processing and analysis of huge volumes of data

In contrast to computerized systems, traditional file management systems can create issues with ______.

organization, repetition, and lack of consistency

Analytic platforms are designed to ______.

quickly gather and analyze specific organizational data to provide information that guides decision making

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, ___ displays information coming out of a database.

reports

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

reports

Select all that apply Which of the following sets of characteristics specifically apply to relational databases? More than one answer may be correct.

A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns). Data tables in a relational database are linked by the fields they have in common.

Brooks Accounting is no stranger to audits—for their customers. Managers discovered some issues in services and billing they suspected were linked to their database practices rather than to employee competence. Brooks hired an outside firm to perform a data quality audit. Which statement best describes how the audit process identified problems?

Data profiling analyzed the accounting firm's data sources.

Which statement best summarizes how organizations use data warehouses?

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

Which statement best explains why traditional file systems have certain issues?

Each file is independent of another file in a traditional system.

Select all that apply 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.

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

This is a screenshot of a portion of a datasheet.(Drag the correct response to the empty box) Where could you click to switch to the Design view? matches

View

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

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

forms

Organizations perform data quality audits in order to ______.

gain an overall assessment of the strengths and weaknesses of their data

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

help a business make strategic decisions based on its own data

A database management system (DBMS) is a computer program that is used to ______.

help organize the data found in a database

The Important goals of data governance (DG) are to ______.

protect data from risk, misuse, regulatory noncompliance, and quality and cost issues

For the past 10 years, a restaurant has been running a customer loyalty program, rewarding customers with discounts and treats. Records of these rewards have been kept in odd notes and multiple spreadsheets used in different ways by various employees who have come and gone over the years. Because of this, some customers are not getting their rewards, while others are receiving rewards they have not earned. Overall, the restaurant is losing money and business with this program. How can a database management system (DBMS) help with this problem?

A DBMS will help the owners manage the data they already have to run their customer loyalty program more efficiently.

Select all that apply Which of the following is an example of why a database should be accessible through the web? More than one answer may apply.

A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. 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 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.

Why must database administrators (DBA) be trained or experienced in using an organization's specific database platform?

They must troubleshoot or solve problems with the database when necessary.

What is the primary role of a database administrator (DBA)?

To monitor the database and ensure that it functions when needed

Referential integrity states that structural relationships in relational databases must ______.

be consistent: a foreign key field that references a primary key field must agree with that primary key

Establishing how an organization manages its data and making sure the organization adheres to these methods is a function called ______.

data administration

Organizing data so that data are in simple tables without any redundancies is known as __________.

data normalization

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

query

Select all that apply Which of the following is an example of what an information policy could specify? More than one answer may apply.

A user agreement on a website indicates that it will store the browsing history linked to the IP address for an indefinite amount of time and reserves the right to sell that information to interested parties. A health insurance company stores data that patients self-report as inputs on its website, but does not link that data with information about the patient's search history. A large corporation grants access to salary information to the direct supervisors of employees and to members of the Human Resources department who administer payroll.

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

Select all that apply Which of the following statements describe the capabilities of relational database management system (RDBMS)? More than one answer may be correct.

RDBMS allow users to view, add, revise, and remove data. RDBMS have features that support the quality and security of data.

Which of the following is a task that an SQL statement would be expected to perform?

Retrieve data

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. Hybrid data marts combine data from a data warehouse and other collection systems. Dependent data marts extract data from a data warehouse when it is needed.

Select all that apply Which of the following is a task that data administration would be responsible for? More than one answer may apply.

Defining policies stating that employees may not share data with people who are not employees of the organization. Determining that two-factor identification must be used to access data that the company has determined to be confidential. Deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app.