5 Key
1.
(p. 181)
Variable-length records contain a variable number of fields with fixed field lengths.
2.
(p. 181)
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.
(p. 181)
A master file is an integrated collection of logically related data elements.
5.
(p. 182)
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.
(p. 190)
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.
(p. 197)
Distributed databases require fewer resources when it comes to computing power and
bandwidth.
23.
(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.
24.
(p. 203)
Having data in independent files makes it easier to provide end users with information for ad
hoc requests.
25.
(p. 203)
In file processing systems, application programs typically contain references to the specific
format of the stored data.
26.
(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.
27.
(p. 207)
Boolean logic was developed during the latter part of the 1900s.
28.
(p. 207)
The Internet is nothing more than the world’s largest database.
29.
(p. 208)
DBMS packages play a major role in application development.
30.
(p. 178)
In all information systems, data resources must be organized and structured in some logical
manner, so that they can be:
31.
(p. 178)
From a logical point of view, a(n) _______________ is the smallest data element that can be
observed and manipulated.
32.
(p. 178)
A record represents a collection of _______________ that describe an entity.
33.
(p. 178)
All the fields used to describe the attributes of an entity are grouped to form a(n)
_______________.
34.
(p. 181)
A group of related records is a data file, or a _______________.
35.
(p. 181)
Variable-length records contain:
36.
(p. 181)
Fixed-length records contain:
37.
(p. 181)
When independent of any other files related to it, a single table is referred to as a(n):
38.
(p. 181)
A(n) _______________ is an integrated collection of logically related data elements.
39.
(p. 182)
Databases contain data elements that describe both entities and the _______________
among entities.
40.
(p. 184)
Database management packages based on the _______________ model can link data
elements from various tables to provide information to users.
41.
(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.
42.
(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.
43.
(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?
44.
(p. 184)
The _______________ model is the most widely used database structure today.
45.
(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
_______________.
46.
(p. 184)
The tables in a relational database are flat files which have rows and columns. Each row
represents a _______________ in the file.
47.
(p. 184)
The tables in a relational database are flat files which have rows and columns. Each column
represents a _______________ in the file.
48.
(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.
49.
(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.
50.
(p. 185)
_______________ is the most commonly used database application for the PC.
51.
(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.
52.
(p. 185)
The _______________ database structure is considered one of the key technologies of a new
generation of Web-based applications.
53.
(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.
54.
(p. 185)
Object technology allows designers to do all of the following except:
55.
(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?
56.
(p. 187)
A database with a(n) _______________ data structure can easily handle a many–to-many
data relationship.
57.
(p. 187)
A database with a(n) _______________ data structure can easily handle ad hoc requests for
information.
58.
(p. 188)
According to one database pioneer, the future development of databases and data
warehouses will depend on _______________.
59.
(p. 188)
Large organizations usually place control of enterprise-wide database development in the
hands of _______________.
60.
(p. 188)
According to the text, most data warehouses will run _______________ in a column format.