chapter 11

Question 1

Provides tools to create data entry forms and specialized programming languages that interface or work with common languages, such as C or Visual Basic.

Answer 1

Application generation subsystem

Question 2

data field (description or characteristic) of some entity (person, place, thing, or object). For example, an employee is an entity with many attributes, including his or her last name, address, phone, etc.

Answer 2

Attribute

Question 3

Processing performed all at once on data that has been collected over time.

Answer 3

Batch processing

Question 4

A single letter, number, or special character, such as a punctuation mark or $.

Answer 4

Character

Question 5

A node one level below the node being considered in a hierarchical database or network

Answer 5

Child node

Question 6

In an object-oriented database, classes are similar objects grouped together.

Answer 6

Class

Question 7

Enormous database an organization develops to cover certain particular subjects. Access to this type of database is usually offered for a fee or subscription. Also known as data bank and informational utility.

Answer 7

Commercial database

Question 8

In a relational database, all related tables must have a common data item or key field.

Answer 8

Common data item

Question 9

Also called shared database. Stored on a mainframe, users throughout the company have access to the database through their personal computers linked by a network.

Answer 9

Company database

Question 10

Raw, unprocessed facts that are input to a computer system that will give compiled information when the computer processes those facts.

Answer 10

data

Question 11

Helps manage the overall database, including maintaining security, providing disaster recovery support, and monitoring the overall performance of database operations.

Answer 11

Data administration subsystem

Question 12

an analysis and visualisation tool that contains collections of time series data on a variety of topics

Answer 12

Data bank

Question 13

A multidimensional data model

Answer 13

Data cube

Question 14

This system defines the logical structure of the database by using a data dictionary.

Answer 14

Data definition subsystem

Question 15

containing a description of the structure of data in a database

Answer 15

Data dictionary

Question 16

Database characteristics relating to the consistency and accuracy of data.

Answer 16

Data integrity

Question 17

includes adding new data, deleting old data, and editing existing data.

Answer 17

Data maintenance

Question 18

Provides tools to maintain and analyze data.

Answer 18

Data manipulation subsystem

Question 19

Technique of searching data warehouses for related information and patterns.

Answer 19

Data mining

Question 20

A common database problem in which data is duplicated and stored in different files.

Answer 20

Data redundancy