Chapter 5 Flashcards

1
Q

The use of integrated collections of data records
and files for data storage and processing

A

Database management
approach

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data in independent files made it difficult to
provide answers to ad hoc requests and required
special computer programs to be written to
perform this task

A

Data integration (

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A specialist in charge of the databases of an
organization.

A

Database administrator
(DBA)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A nonprocedural computer language used to
interrogate a database.

A

Structured Query Language
(SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Defines and catalogs the data elements and data
relationships in an organization’s database

A

Data dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A feature of database systems that uses queries or
report generators to extract information.

A

Database interrogation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

The main software package that supports a database
management approach.

A

Database management system
(DBMS) (2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Databases that are dispersed over the Internet and
corporate intranets and extranets.

A

Distributed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Databases that organize and store data as objects.

A

Object-oriented model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Databases of hyperlinked multimedia documents
on the Web.

A

Hypermedia

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The management of all the data resources of an
organization.

A

Data resource management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Processing data in a data warehouse to discover
key business factors and trends.

A

Data mining (

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Developing conceptual views of the relationships
among data in a database.

A

Data modeling

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A customer’s name.

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

. A customer’s name, address, and account balance.

A

Record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The names, addresses, and account balances of all
of your customers.

A

File

17
Q

An integrated collection of all of the data about
your customers.

A

Database

17
Q

Business application programs that use specialized
data files.

A

File processing

18
Q

A treelike structure of records in a database.

A

Hierarchical structure (1

19
Q

A tabular structure of records in a database.

A

Relational model

20
Q

Records organized as cubes within cubes in a
database.

A

Multidimensional model

21
Q

Databases that support the major business processes
of an organization

A

Operational (

21
Q

A centralized and integrated database of current
and historical data about an organization.

A

Data warehouse

22
Q

A problem in the file processing approach where
major components of a system are dependent on
each other to a large degree

A

Data dependence (

22
Q

Databases available on the Internet or provided by
commercial information services

A

External (

23
Q

Different approaches to the logical organization of
individual data elements stored in a database.

A

Database structures (

24
Q

The most basic logical data element corresponding
to a single letter or number.

A

Character (

25
Q

A feature of distributed databases that identifies
changes in one database and then makes appropriate changes in the others.

A

Replication

26
Q

Data that describe the structure and characteristics
of databases.

A

Metadata

26
Q

A characteristic of data that refers to their accuracy and completeness.

A

Data integrity

27
Q

A characteristic or quality of some entity used to
describe that entity

A

attribute

28
Q

Includes, among others, operational, distributed,
and hypermedia databases.

A

Types of database

29
Q

The existence of duplicate data among different
files in an organization.

A

Data redundancy

30
Q

An approach to distributed databases that copies
the complete content of a master database to others
at a prescribed time of the day.

A

Duplication

31
Q

An object, person, place, event, and so on that is of
interest to an organization and thus included in a
database.

A

Entity

32
Q

An approach to database structure that improves
on the hierarchical model by allowing many-tomany relationships.

A

network structure

33
Q

Different levels of data groupings that exist in a
database.

A

Logical data element