csci final- ch 11

in a relational database, what is a relationship

a link between tables that defines how the data are related

microsoft ____ is a database management system

access

an individual trained in the design and building of databases is called a database _____

administrator

in a transaction-processing system, if transaction data are accumulated untul a certain point and then many transactions are processed all at once, this is called ____ processing

batch

a database schema is also called a

data dictionary

classification, affinity, grouping, and estimation are ____ methods used by managers to make their data more meaningful

data mining

a ____ is a collection of related data that can be stored, sorted, organized, and queried

database

which of the following is NOT a typical disadvantage associated with databases?

database information cannot be changed once it is entered

what does the acrnonym DBMS stand for

database managment system

a _____ is automatically displayed in a field unless the user enters something different

default value

a ____ temporarily displays records that match the specified criteria

filter

which of the following is NOT a main operation of a database management system (DBMS)?

implementing data mining

data _____ means that the data contained in a database is accurate and reliable

integrity

an expert system and a natural language processing system are both

knowledge based systems

data staging consists of all of the following steps, EXCEPT

mining of data

_____ is the process of reducing data redundancy by recording data only once

normalization

each record must have a unique field called a ____ field

primary key

a ____ is a way of retrieving information from one or more tables that defines a particular subset of data

query

in a transaction-processing system (TPS), if the TPS database is queried and updated while the transaction is taking place, this called ____ processing

real-time

in a database, a ___ is a group of related fields

record

_____ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table

referential integrity

____ databases have the largest market share among the primary types of electronic databases

relational

SQL uses ____ to extract records from a database by using english-like expressions that have variables and operations

relational algebra

a ____ displays a subset of data from a table or tables based on the criteria specified

select query

a data _____ is a large-scale electronic repository of data that contains and organizes all of an organizations data in one place

warehouse