Comp Sci Chapter 11

True

the National missing persons DNA database is part of the CODIS system

Record

A _ contains the info for a single entity in a database

False

A data warehouse is used to discover relationships among data items

Flat

An Excel spreadsheet is an example of an _____ database

Cognitive computing system

An _ improves over time by learning from its interactions

Make decisions in real life situations

An expert system is a computer programmed to

True

Durability as related to transaction processing means that once a transaction has been completed it cannot be undone.

OSS

Improves productivity of employees by automating common tasks

Fields

In a database, title, author, publication date, and ISBN are examples of

Bioinformatics

Is the application of info technology to the field of biology

IAFIS

National fingerprint and criminal history system

MIS

Provides information on daily operations

TPS

Responds to user requests such as the exchange of goods, services, or money

False

The test that a transaction processing system used to make sure that each transaction is independent is known as durability.

CODIS

Used by law enforcement to link cases and identify suspects

True

When designing a database you should have separate fields for a person's first and last names

Quit

Which is not a SQL relational keyword?

Social security number

Which would make the best primary key in a table?

OLAP

____ Allows users to selectively extract data from different viewpoints.