Exam 9: Data Design

One common method of indicating ____ is called crow's foot notation because of the shapes, which include circles, bars, and symbols that indicate various possibilities.

Michelle tells Malia that a primary key is a field or combination of fields that uniquely and minimally identifies a particular entity. She explains that there may be a choice of fields or field combinations to use as the primary key. What is the term used for a possible primary key?

The basic elements of logical data are alphabetic or numeric characters, such as the letter A or the number 9.

With a(n) ____ language, the user provides an example of the data requested.

Any field that is not a primary key or a candidate key is called a ____ key.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Kind of storage that refers to information as seen through a user's eyes, regardless of how or where the information actually is organized or stored.

In a DBMS, the file-oriented tables form a unified data structure. _________________________

In a file-oriented information system, a transaction file ____.

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

A data ____, which is a framework for organizing and storing data, consists of one or more files or tables.

Briefly describe (including examples in your answer) at least six of the common coding methods.

Which of the following is a problem found with 1NF (first normal form) design that does not exist in 2NF (second normal form)?

JDBC enables ____ applications to exchange data with any database that uses SQL statements and is compliant with the standard.

____ is the process of creating table designs by assigning specific fields or attributes to each table in a database.

An intranet is an extension of a company Web site that allows access by external users, such as customers and suppliers. _________________________

Physical storage involves a(n) ____________________, which is the smallest data unit that can be handled by the operating system.

A table is in first normal form (1NF) if it contains a repeating group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A field or combination of fields that can be used to access or retrieve records.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A private, company-owned network to provide Web-based access to users.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A view of a database used by one or more systems or users.