Chapter 5 Flashcards

(37 cards)

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.

17
Q

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

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
Databases available on the Internet or provided by commercial information services
External (
23
Different approaches to the logical organization of individual data elements stored in a database.
Database structures (
24
The most basic logical data element corresponding to a single letter or number.
Character (
25
A feature of distributed databases that identifies changes in one database and then makes appropriate changes in the others.
Replication
26
Data that describe the structure and characteristics of databases.
Metadata
26
A characteristic of data that refers to their accuracy and completeness.
Data integrity
27
A characteristic or quality of some entity used to describe that entity
attribute
28
Includes, among others, operational, distributed, and hypermedia databases.
Types of database
29
The existence of duplicate data among different files in an organization.
Data redundancy
30
An approach to distributed databases that copies the complete content of a master database to others at a prescribed time of the day.
Duplication
31
An object, person, place, event, and so on that is of interest to an organization and thus included in a database.
Entity
32
An approach to database structure that improves on the hierarchical model by allowing many-tomany relationships.
network structure
33
Different levels of data groupings that exist in a database.
Logical data element