Exam 5: Database Management Systems

The ______________________________ approach to business event processing concentrates on the process being performed,with data playing a secondary or supportive role to the programs.

A computer's ability to imitate human decision making when confronting situations that are complex and ambiguous is called ______________________________.

Data mining refers to the exploration,aggregation,and analysis of large quantities of varied data from across the organization.

An expert system helps make complex decisions consistently.

A(n)______________________________ can be used to capture and retain the expertise of retiring employees.

Primary key ______________________________ in a relational table must be a unique identifier for a row.

Classifying data refers to grouping or categorizing data according to some common attributes.

The mapping of the relationships between entities would be used in the development of a(n):

List 1 shows the coding schemes discussed and illustrated in Chapter 5,while List 2 contains eight coding examples. Required: On your solution sheet,list the numbers 1 through 8 from List 2.Next to each number,show the capital letter from List 1 that best describes the coding type represented by each example.HINT: Some letters from List 1 may be used for more than one coding example,while some letters may not be used at all.

Normalize the database structure in Figure TB 5.1 by transforming it into first normal form (1NF).

The uniform product codes (UPC)used in supermarkets is a type of:

When different information about the same fact is stored in different files the integrity of the data is violated.

A table is in ______________________________ if it is in first normal form and no non-key attribute is dependent on only a portion of the primary key.

Another name for sequential coding is:

The model that logically organizes data into two-dimensional tables is the:

In the applications approach to business event processing,a data change in one application before updating another application could lead to:

______________________________ is the use of information systems facilities to focus on the collection,organization,integration,and long-term storage of entity-wide data.

Update anomalies are problems in a relation table caused by the existence of functional dependencies.

In the network database model,a child record can have more than one parent record.

Because it uses alphabetic characters,a sequential coding system is most understandable to human beings.