ch5 Key
1.
Variable-length records contain a variable number of fields with fixed field lengths.
2.
When independent of any other files related to it, a single table is referred to as a compressed file.
3.
(p. 181)
Files are frequently classified by the application for which they are primarily used, such as a payroll
file or an inventory file.
4.
A master file is an integrated collection of logically related data elements.
5.
Databases contain data elements that describe both entities and the relationships among entities.
6.
(p. 184)
Database management packages based on the relational model can link data elements from various
tables to provide information to users.
7.
(p. 185)
The project operation is used to create a subset of the columns contained in the temporary tables
created by the select and join operations.
8.
(p. 185)
A major benefit of multidimensional databases is that they are a compact and easy-to-understand way
to visualize and manipulate data elements that have many interrelationships.
9.
(p. 185)
Multidimensional databases have become the least popular structure for analytical databases that
support online analytical process (OLAP) applications, in which fast answers to complex queries are
expected.
10.
(p. 185)
The multidimensional database structure is considered one of the key technologies of a new
generation of Web-based applications.
11.
(p. 187)
A database with a network data structure can easily handle a many-to-many data relationship, whereas
a hierarchical model cannot.
12.
(p. 187)
The network model can easily handle ad hoc requests for information, whereas the hierarchical model
cannot.
13.
(p. 187)
All of the relationships between the data elements in a relationally organized database need to be
specified when the database is created.
14.
(p. 187)
Relational databases are more difficult for programmers to work with and more difficult to maintain
than the hierarchical and network models.
15.
(p. 188)
Large organizations usually place control of enterprise-wide database development in the hands of
database administrators (DBAs) and other database specialists.
16.
(p. 189)
An active data dictionary will prevent a data entry program from using a nonstandard definition of a
customer record.
17.
A data model serves as a logical framework on which to base the physical design of a database.
18.
(p. 193)
Distributed databases can reside on network servers on the World Wide Web, on corporate intranets,
or on corporate extranets.
19.
(p. 196)
A large database system is often distributed into smaller databases based on some logical relationship
between the data and the location of the databases.
20.
(p. 197)
In a distributed database system, each location gains control of its local data, but loses access to data
in other locations.
21.
(p. 197)
One drawback to the database duplication process is that no changes can ever be made to any database
other than the master. Otherwise, local changes will be overwritten during the duplication process.
22.
Distributed databases require fewer resources when it comes to computing power and bandwidth.
23.
Automobiles contain very little useful business information about consumers.
24.
(p. 202)
In a traditional file processing approach, each business application is designed to use one or more
specialized data files containing only specific types of data records.
25.
(p. 203)
Having data in independent files makes it easier to provide end users with information for ad hoc
requests.
26.
(p. 203)
In file processing systems, application programs typically contain references to the specific format of
the stored data.
27.
(p. 203)
In file processing systems, it was easy for data elements, such as stock numbers and customer
addresses, to be defined differently by different end users and applications.
28.
Boolean logic was developed during the latter part of the 1900s.
29.
The Internet is nothing more than the world’s largest database.
30.
DBMS packages play a major role in application development.
31.
(p. 178)
In all information systems, data resources must be organized and structured in some logical manner,
so that they can be:
32.
(p. 178)
From a logical point of view, a(n) _______________ is the smallest data element that can be observed
and manipulated.
33.
A record represents a collection of _______________ that describe an entity.
34.
(p. 178)
All the fields used to describe the attributes of an entity are grouped to form a(n)
_______________.
35.
A group of related records is a data file, or a _______________.
36.
Variable-length records contain:
37.
Fixed-length records contain:
38.
When independent of any other files related to it, a single table is referred to as a(n):
39.
A(n) _______________ is an integrated collection of logically related data elements.
40.
(p. 182)
Databases contain data elements that describe both entities and the _______________ among
entities.
41.
(p. 184)
Database management packages based on the _______________ model can link data elements from
various tables to provide information to users.
42.
(p. 184)
Early mainframe DBMS packages used the _______________ structure, in which all records are
dependent and arranged in multilevel structures, consisting of one root record and any number of
subordinate levels.
43.
(p. 184)
In a(n) _______________ database structure, all of the relationships among records are one-to-many,
because each data element is related to only one element above it.
44.
(p. 184)
Which database model allows many-to-many relationships among records so that a data element can
be accessed by following one of several paths?
45.
The _______________ model is the most widely used database structure today.
46.
(p. 184)
In the relational database model, all data elements within the database are viewed as being stored in
the form of simple two-dimensional tables, sometimes referred to as _______________.
47.
(p. 184)
The tables in a relational database are flat files which have rows and columns. Each row represents a
_______________ in the file.
48.
(p. 184)
The tables in a relational database are flat files which have rows and columns. Each column represents
a _______________ in the file.
49.
(p. 185)
The _______________ operation is used to create a subset of the columns contained in the temporary
tables created by the select and join operations.
50.
(p. 185)
Using a relational database, a user can temporarily combine two or more tables so that he/she
can see relevant data in a form that looks like it is in one big table. This is the _______________
operation.
51.
_______________ is the most commonly used database application for the PC.
52.
(p. 185)
_______________ databases have become the most popular structure for analytical databases that
support online analytical process (OLAP) applications, in which fast answers to complex queries are
expected.
53.
(p. 185)
The _______________ database structure is considered one of the key technologies of a new
generation of Web-based applications.
54.
(p. 185)
The object-oriented database model supports _______________. That is, new objects can be
automatically created by replicating some or all of the characteristics of one or more parent
objects.
55.
Object technology allows designers to do all of the following except:
56.
(p. 187)
Which database structure works effectively with complex data types, such as video clips, audio
segments, and other subsets of Web pages, and is considered one of the key technologies of Web-
based applications?
57.
(p. 187)
A database with a(n) _______________ data structure can easily handle a many-to-many data
relationship.
58.
(p. 187)
A database with a(n) _______________ data structure can easily handle ad hoc requests for
information.
59.
(p. 188)
According to one database pioneer, the future development of databases and data warehouses will
depend on _______________.
60.
(p. 188)
Large organizations usually place control of enterprise-wide database development in the hands of
_______________.
61.
According to the text, most data warehouses will run _______________ in a column format.
62.
(p. 189)
Database administrators and database design analysts work with end users and systems analysts to do
all of the following except: