IS Final 3100 Ch.6-

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

Data integrity is increased when ______.

centralized

To create a relationship between two tables, you must use a ________ field that is present in both tables.

common

We use database forms to control how ________ enters a database.

data

Organizations perform data quality audits in order to ______.

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

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

help organize the data found in a database

The DBMS (Database Management System) is designed to administer and ________ a database.

organize

Areas covered in digital governance include data architecture, data quality, data modeling, data warehousing, and data ________.

security

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

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

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

Select the true statements about the balanced scorecard method for decision making.

Choice The balanced scorecard framework was developed by Robert Kaplan and David Norton and is used to structure an organization's strategic plan and goals. , Choice In order to get the information they need to create a balanced scorecard, managers rely on output provided from executive support systems (ESS). Measurable outcomes on a balanced scorecard include financial, internal business processes, learning and growth, and customers.

Which of the following are contemporary management behaviors?

Currency of information Diversity of contacts with the organization Oral communication

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

Data Type

Decision Role

Managers help to initiate new strategic objectives, handle conflicts, and distribute budgetary resources to departments and employees under their supervisory control.

What does the acronym NoSQL stand for?

Non-relational databases

OLAP software allows users to perform multidimensional analysis of a wide range of business data, complex calculations, and trend analysis, as well as data modeling. What does OLAP stand for?

Online Analytical Processing

Of the decisions/activities listed, which would be considered structured decisions?

Payroll and overtime decisions Inventory decisions

.The classical model of management describes what managers do. Classical management theorist Henry Fayol identified the five classical functions of managers which includes:

Planning Organizing Coordinating

High-velocity decision making systems

Software that is created by humans and is designed to identify issues, find solutions to these issues, and implement the programs needed to overcome these issues with an emphasis on transactional speedm

Which statement best summarizes how a data governance (DG) plan is created? Multiple choice question. The plan is limited by what is technically possible, given the available technology. The plan is tailored to the organization's specific goals, objectives, and activities. The plan is based on the need to comply with government regulations for data security. The plan is developed from departmental plans that are merged into one for the whole organization.

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

Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries? More than one answer may be correct.

Update query Delete query Append query

Commonly used techniques to gain information in web mining include ________, ________,and ________.

WCM, WSM, WUM

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

Alerting online customers that the desired item is out of stock, before the order is placed 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

Informational Roles

In their informational capacity, managers are the central location for information provided by the organization.

Select the true statements about the analytical hierarchy process (AHP) model.

Intricate situations and scenarios are analyzed by deconstructing the problem into a visible hierarchy that can be analyzed through comparison. Allows for many variables or conditions to be considered and prioritized, resulting in the selection of the best alternatives or projects. A multi-criteria programming model that uses an analytical hierarchy process for decision making.

structured decisions

Management decisions that involved tasks and choices that encompass prescribed and definite procedures for how they should be handled are referred to as structured decisions.

Databases maintain data and information about various types of data ________.

object

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.

Data mining is best described as ______. Multiple choice question. 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 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 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 ________ key must contain a unique value.

primary

Analytic platforms are designed to ______. Multiple choice question. quickly calculate and interpret varying measures of data and automate the decision-making process generate automatic reports on the performance of an organization's diverse business areas and operations quickly gather and analyze specific organizational data to provide information that guides decision making use dedicated hardware, software, and networks to analyze large data sets from the organization's social media

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

Interpersonal role

where managers represent their business to stakeholders outside the organization and perform a number of figurative responsibilities such as communicating with the public and recognizing employee performance.