A grouping of characters into a word, a group of words, or a complete number is called a record.
In normalization, complex groupings of data are streamlined to eliminate awkward
DBMS simplify how end users work with databases by separating the logical and physical views
of the data.
OLAP is used to find hidden patterns and relationships in large databases, and infer rules from
these to infer future behavior.
A firm's information policy lays out who is responsible for updating and maintaining the
information in a database system.
The use of different terms for identifying data in a firm's various information systems is an
example of redundant data.
It is a quality-of-data concept that is used to identify a companyʹs most important data.
Which of the following is not a true statement about MDM?
I dentify the data needed to run the business
What is the first step you should take in managing data for a firm?
The entity CUSTOMER with the attribute ADDRESS
Which of the following best illustrates the relationship between entities and attributes?
The type of logical database model that treats data as if they were stored in two-dimensional
tables is the:
Relationships between entities
What are the relationships that the relational database is named for?
five tables: for customers, employees, suppliers, products, and sales.
The most basic business database is comprised of
A field identified in a table as holding the unique identifier of the table's records is called the:
A field identified in a record as holding the unique identifier for that record is called the
A schematic of the entire database that describes the relationships in a database is called a(n):
in two short marks.
A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:
with a crow's foot preceded by a short mark.
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:
A table that links two tables that have a many-to-many relationship is often called a(n)
The process of streamlining data to minimize redundancy and awkward many-to-many
relationships is called
select, project, and join
In a relational database, the three basic operations used to develop useful sets of data are
creates a subset consisting of all records in the file that meets stated criteria
The select operation:
combines relational tables to provide the user with more information than is otherwise
The join operation
creating an inventory of data definitions contained in the database
The data dictionary serves as an important data management tool by
An automated or manual file that stores information about data elements and data
characteristics such as usage, physical representation, ownership, authorization, and security is
data manipulation language.
The specialized language programmers use to add and change data in the database is called
display data in an easier-to-read format
DBMS typically include report-generating tools in order to:
Which of the following database types is useful for storing Java applets as well as handling large
numbers of transactions?
Data warehouse systems provide easy-to-use tools for managers to easily update data.
Which of the following statements about data warehouses is not true?
it typically focuses on a single subject area or line of business
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users
make better business decisions are known as
The tool that enables users to view the same data in different ways using multiple dimensions is
users to obtain online answers to ad hoc questions in a rapid amount of time.
OLAP is a tool for enabling
occurrences linked to a single event
In terms of the data relationships found by data mining, associations refers to
events linked over time
In terms of the data relationships found by data mining, sequences refers to
An alternative to using application server software for interfacing between a Web server and
back-end databases is
Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and
The confusion created by ________ makes it difficult for companies to create customer
relationship management, supply chain management, or enterprise systems that integrate data from different sources.
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly
formatted, or redundant is called
Web usage mining
Which of the following would you use to find patterns in user interaction data recorded by Web