VT Chapter 11

Question 1

database

Answer 1

collection of information that is organized in a useful way

Question 2

table

Answer 2

database object in which data is stored, arranged in rows and columns

Question 3

field

Answer 3

single piece of information in a record within a database (column)

Question 4

record

Answer 4

information for a single entity in the database (row)

Question 5

primary key

Answer 5

special field in a record that uniquely identifies the record in the table

Question 6

Forms

Answer 6

a database object that makes it easier to enter data into a database table and displays the information in an easy to read layout

Question 7

Report

Answer 7

displays data from a table or a query in a format that is easy to read and print

Question 8

query

Answer 8

retrieves specific data from one or more tables

Question 9

A _______ is a collection of related information

Answer 9

database

Question 10

A table is a database object in which data is stored. It is arranged in rows called _____ and columns called ______.

Answer 10

records, fields

Question 11

The _____ uniquely identifies a record in a table.

Answer 11

primary key

Question 12

flat databse

Answer 12

consists of a single list of items

Question 13

relational database

Answer 13

consists of multiple tables that are related by common information

Question 14

one to many relationship

Answer 14

when a single record in a table links to multiple records in another table

Question 15

one to one relationship

Answer 15

a record in one table is linked to a single record in another table.

Question 16

object oriented database (OODB)

Answer 16

data is stored as objects

Question 17

multidimensional database (MDB)

Answer 17

structures the information into multidimensional data cubes.

Question 18

data warehouse

Answer 18

central repository for all the data that an enterprise uses

Question 19

Database management system (DBMS)

Answer 19

software used to create and manage data in a database

Question 20

data dictionary

Answer 20

defines all the fields and the type of data each field will contain

Question 21

data type

Answer 21

defines the kind of data that you can enter in a field, including text, numbers, dates, images, and hyperlinks

Question 22

data normalization

Answer 22

reduces the size of a database making it easier to keep records up to date and increases query speed

Question 23

data validation

Answer 23

reduces data entry errors by using validation rules such as data type, data length, acceptable values, and required fields.

Question 24

database administrator (DBA)

Answer 24

person who manages database systems

Question 25

The design of a database starts with the data ________

Answer 25

dictionary

Question 26

Good database design use _______ to reduce data redundancy

Answer 26

normalization

Question 27

_________ reduces data entry errors

Answer 27

Data validation

Question 28

_______ is used to manipulate, query, and update data in relational databases.

Answer 28

SQL

Question 29

information system

Answer 29

the people, hardware, and software that supports data intensive applications such as financial accounts, human resources and other business transactions

Question 30

Office support systems (OSS)

Answer 30

include software and hardware that improve the productivity of employees by automating common tasks

Question 31

management information system

Answer 31

includes software, hardware, data resources, decision support systems, people and project management applications

Question 32

Business Intelligence Tools

Answer 32

applications that are used to analyze data in information systems to help make decisions

Question 33

Artificial Intelligence

Answer 33

the branch of science concerned with making computers behave like humans

Question 34

expert system

Answer 34

a computer programmed to make decisions in real life situations

Question 35

knowledge base (part of expert system)

Answer 35

contains expert knowledge and accumulated experience in a particular field

Question 36

Inference engine (part of expert system)

Answer 36

A set of rules for applying the knowledge base to each particular situation

Question 37

_________ consist of people, hardware and software.

Answer 37

Information systems

Question 38

___________ links together multiple operations and ensures that all operations in a transaction are completed without error.

Answer 38

Transaction Processing

Question 39

IAFIS (Integrated Automated Fingerprint Identification System)

Answer 39

national fingerprint and criminal history system maintained by the FBI and used by local, state and federal law enforcement

Question 40

CODIS (Combined DNA Index System)

Answer 40

searches across multiple local, state, and national DNA profile databases

Question 41

Bioinformatics

Answer 41

the application of information technology to the field of biology

Question 42

Geographic Information System (GIS)

Answer 42

combines layers, or datasets, of geographically referenced information about Earth's surface

Question 43

_________ searches across multiple DNA indexes for a potential match

Answer 43

CODIS

Question 44

IAFIS is now ______

Answer 44

Next Generation Identification (NGI)

Question 45

The Human Genome project is an example of ________

Answer 45

Bioinformatics