Exam 5: Database Management Systems

The centralized database approach to business event processing,in which facts about events are stored in relational database tables instead of separate files,solves many of the problems caused by data redundancy.

Data flows that provide a basis for managerial decisions are called ____ information flows.

The ______________________________ approach to database design attempts to describe all aspects of the business events and processes under consideration.

The goal of ______________________________ is to produce a database model that contains relationships that are in 3NF.

Business processes,such as hiring employees,purchasing inventory,and collecting cash from customers,are called events.

A(n)______________________________ is an information system that assists managers with unstructured decisions by retrieving and analyzing data for purposes of identifying and generating useful information.

Decoupling the data from the system applications is a major difference between the centralized database approach and the applications approach and is known as:

The model that includes abstract types that allow users to define data to be stored in the database is the:

The applications approach to data management decouples the data from the applications or other users of the data.

Grouping or categorizing data according to common attributes is called:

In an entity-relationship diagram,____ are used to show the characteristics of relationships.

The uniform product codes (UPCs)used by supermarkets and other retailers are examples of a block coding scheme.

______________________________ is a measure of the highest level of participation that one entity can have in another entity.

______________________________ is a method for freely and creatively generating as many ideas as possible without undue regard for their practicality or realism.

A partial dependency happens when an attribute that is dependent on a portion of the primary key not on the entire key.

A data model for a database is often depicted using entity-relationship diagrams.

Another name for sequential coding is ______________________________ coding.

A(n)______________________________ is the attribute whose value is unique for every entity that will appear in the database.

In an object-oriented database model,what types of objects can be stored through use of abstract data types,inheritance,and encapsulation?

The information system which emulates the problem-solving techniques of humans is called a(n):