Exam 9: Data Design

One problem in a file processing environment is ____, which means that data common to two or more information systems is stored in several places.

One type of validity check, called ____ integrity, is a set of rules that avoids data inconsistency and quality problems.

To bridge the gap between a database and the Web and enable data to be viewed and updated, it is necessary to use ____, which is software that integrates different applications and allows them to exchange data.

In a typical file processing environment, ____ problems can occur if updates are not applied in every file.

____________________ combine data from different item attributes, or characteristics, to build the code.

Which of the following is a data coding and storage scheme?

-In the accompanying figure, a ____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -As an analyst, you must understand this in order to create a data design that accurately reflects all relationships among system entities.

Typically, a DBMS is managed by a person called a(n) ____________________, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

A ____ contains data about people, places, things, or events that interact with a system.

The ____________________ for database design, which was introduced in the 1970s and became popular because it was flexible and powerful, uses common fields to establish relationships between tables.

Relational databases are poorly suited to client/server computing because they are so powerless and rigid.

Field X is functionally dependent on field Y if the value of field X depends on the value of field Y.

Like a primary key, a foreign key must be unique.

Some abbreviation codes are called ____ codes because they use a specific combination of letters that are easy to remember.

HTML uses formatting codes called ____, which specify how the text and visual elements on a Web page will be displayed in a Web browser.

Normal forms beyond 3NF exist, but they rarely are used in business-oriented systems.

When a primary key combines two or more fields, it is called any of the following EXCEPT a ____ key.

____ codes use a keyword to encode a number.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A widely used method of visualizing and documenting software systems design.