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