CNT3604 CH 5

record

5. A collection of fields about a specific object is a(n)_______.

True

5. A data warehouse is used to support decision making while and OLTP database is used to support transaction processing

True

5. A data warehouse stores historical data that has been extracted from operational systems, external sources, and, sometimes, even unique sources.

Distributed database

5. A database in which data can be spread across several smaller databases connected through telecommunications devices is called a(n)_________.

files

5. A database is a collection of integrated and related __________

False

5. A database need not reflect the business processes of the organization

False

5. A database provides one of many points of management and control over data resources

data model

5. A tool that database designers use to show the logical relationships among data is a(n) __________.

Data mart

5. A(n) _________ contains a subset of data for a single aspect of a company's business and are used by smaller groups who want to access detailed data for business analysis

data warehouse

5. A(n)_____________ typically stores three to ten years of historical summary data records from many operational systems and external data sources so that it can be used for business analysis.

database

5. A_________.helps companies reduce costs, increase profits, track past business activates, and open new market opportunities.

False

5. An attribute is a general class of people, places, or things for which data is collected, stored, and maintained

attribute

5. As long as the tables in a relational database share one common _________, the tables can be linked to provide useful information and reports

False

5. Business and technology vendors are working to develop blue data centers that run more efficiently and require less energy for processing and cooling.

False

5. Business intelligence turns data into useful information that then is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

True

5. Carrying summary totals in the data records is an example of planned data redundancy

false

5. Competitive intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means

True

5. Data centers are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a "lights out" environment.

Drill down

5. Data warehouses allow managers to ______ to get increasing levels of detail about business conditions.

False

5. Database management system cost in excess of one thousand dollars

False

5. Database management system cost in excess of one thousand dollars.

False

5. Due to their size, databases must be stored on mainframe computers or other large, powerful computers. QUIZ

False

5. Identification of who will have access to a database has little impact on organizing a database.

True

5. In some cases, multiple organizations collaborate in creating and using internationally databases

True

5. In the relational model, each row of a table represents a data or record and each column of the table represents an attribute or field

True

5. One of the first steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

True

5. One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically

False

5. Online Analytical Processing and data mining are essentially the same thing

False (1/2)

5. Oracle is currently the market leader in general purpose databases, with about three-fourths of the multibillion dollar database market

True

5. Projecting involves eliminating columns in a table

database administrator

5. Someone responsible for planning, designing, creating, operating, securing, monitoring, and maintain databases is called a(n)___________.

True

5. The DBMS serves as an interface between an application program and the database. QUIZ

False

5. The Database Administrator decides the contents of the database with little or not input from the users of the database.

True

5. The analysis of data on user traffic through an organizations web site is an example of data mining.

False

5. The domain for pay rate would include both positive and negative numbers.

All of the above

5. The process of selecting the best database management system for an organization considers ___________.

False

5. The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Bit

5. The smallest piece of data used by a computer is the _______.

True

5. Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data

Database as a service

5. With _______, the databases is stored on a service provider's server and accessed by the client over a network, typically the internet.

Counterintelligence

5. _________ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers

SQL

5. _________ is a standardized data manipulation language developed in the 1970's that allows programmers to use one powerful language and use it on a variety of systems.

Query by example

5. ___________ is a visual approach to developing database requests

Market basket analysis

5. ___________ is an application of data mining the identifies the products and services most commonly purchased at the same time

Spatial data technology

5. ____________ involves using a database to store and access data according to the locations it describes and to permit spatial queries and analysis

data anomaly

A data abnormality that exists when inconsistent changes to a database have been made. For example, an employee moves, but the address change is corrected in only one file and not across all files in the database.

entity

A general class of people, places, or things for which data is collected, stored and maintained is known as __________. QUIZ

database management system (DBMS)

A group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs is called a(n) _______. SAT

DBMS

A group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs is called a(n) _______________.

primary key

A(n) _______________ is a field or set of fields that uniquely identifies a database record. SAT

database administrator

A(n) _______________ is a skilled and trained IS professional who directs all activities related to an organization's database. SAT

entity relationship

A(n) _______________ uses basic graphical symbols to show the organization of and relationships between data.

False

After data has been placed into a relational database, users can make inquiries and analyze data. Basic data manipulations include selecting, projecting, and optimizing.

selecting

Basic data manipulations include __________ which involves eliminating rows in a relational database.

schema

Because the DBMS is responsible for providing access to a database, one of the first steps in installing and using a database involves telling the DBMS the logical and physical structure of the data and relationships among the data in the database. This description of an entire database is called a(n) _______________. SAT/QUIZ

False

Data redundancy is a desirable quality in a database.

projecting

Manipulating data to eliminate columns in a table is known as______ QUIZ

data center

Many businesses store their database and related systems in climate-controlled facilities called _________________. SAT

business intelligence

The process of gathering enough of the right information in a timely manner and usable form and analyzing it to have a positive impact on business strategy, tactics or operations is called ________. SAT/QUIZ

cleanup

The purpose of data______ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure. QUIZ

data dictionary

This is a detailed description of all data used in the database. QUIZ

primary key

This is a field or set of fields that uniquely identifies a database record. QUIZ

planned data redundancy

This is a way of organizing data in which the logical database design is altered so that certain data entities are combined, or summary totals are carried in the data records rather than calculated from elemental data, or some data attributes are repeated in more than one data entity to improve database performance. QUIZ

data administrator

This is the name of a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization. QUIZ

relational

What database model places data in two-dimensional tables? SAT

concurrency

______ control can be used to avoid potential problems when two or more users attempt to access the same record at the same time. QUIZ

Joining

_______________ involves manipulating (combining) data to combine two or more database tables. SAT/QUIZ

object-relational database management system (ORDBS)

a DBMS capable of manipulating audio, video, and graphical data

character

a basic building block of information, consisting of uppercase letters, lowercase letters, numeric digits, or special symbols

attribute

a characteristic of an entity

data definition language (DDL)

a collection of instructions and commands used to define and describe data and relationships in a specific database

file

a collection of related records

distributed database

a database in which the data can be spread across several smaller databases connected via telecommunications devices

relational model

a database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files

data warehouse

a database that collects business information from many sources in the enterprise, covering all aspects of the company's processes, products, and customers

replicated database

a database that holds a duplicate set of frequently used data

object-oriented database

a database that stores both data and its processing instructions

schema

a description of the entire database

data model

a diagram of data entities and their relationship

key

a field or set of fields in a record that used to identify the record

predictive analysis

a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events, such as future product sales or the probability that a customer will default on a loan

object-oriented database management system (OODBMS)

a group of programs that manipulate an object-oriented database and provide a user interface and connections to other application programs

database administrator (DBA)

a skilled IS professional who directs al activities related to an organization's database

database approach to data management

an approach whereby a pool of related data is sharing by multiple application programs

traditional approach to data management

an approach whereby separate data files are created and stored for each application program

hierarchy of data

bits. characters, fields, records, files and databases

linking

data manipulation that combines two or more tables using common data attributes to form a new table with only the unique data attributes

enterprise data modeling

data modeling done at the level of entire enterprise

entity-relationship (ER) diagrams

data models that use basic graphical symbols to show the organization of the relationship between data

single user database

example: Access

multi-user database

example: SAP, Oracle

back-end application

interacts with other programs or applications; it only indirectly interacts eith people or users

the object data standard

is a design standard created by the object database management group for developing object oriented database system

flat file

is a simple database program whose records have no relationship to one another

front-end application

is one that directly interacts with people or users

competitive intelligence

one aspect of business intelligence limited to information about competitors and the ways that knowledge affects strategy, tactics, and operations

online analytical processing (OLAP)

software that allows users to explore data from a number of perspectives

data item

the specific value of an attribute

counterintelligence

the steps an organization takes to protect information sought by "hostile" intelligence gatherers

field

typically a name, number, or combination of characters that describes an aspect of a business object or activity