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