Exam 9: Data Design

Intranets and extranets are called Web-centric because they use different protocols, or data transmission standards, than the Internet.

-In the table or file shown in the accompanying figure, a(n) ____________________ is a single characteristic or fact about an entity.

Many database programs generate ____, which is a language that allows PC client workstations to communicate with servers and mainframe computers.

A common field is an attribute that appears in only one entity.

A table design specifies the fields and identifies the primary key in a particular table or file.

While a data warehouse typically spans the entire enterprise, many firms prefer to use a(n) ____________________, which is designed to serve the needs of a specific department, such as sales, marketing, or finance.

In a client/server system, processing is isolated in one part of the organization.

In a client/server design, tasks are divided between servers, which are workstations that users interact with, and clients, which are computers that supply data, processing, and services to the server workstations.

In an entity-relationship diagram, entities are represented as ____.

A table design is in second normal form (2NF) if it is in 1NF and if all fields that are not part of the primary key are functionally independent of part of the primary key.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A person, place, thing, or event for which data is collected and maintained.

A data ____ language controls database operations, including storing, retrieving, updating, and deleting data.