Exam 9: Data Design

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A coding method used on mainframe computers and high-capacity servers

A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value.

In a web-based design, the Internet serves as the _____ for the database management system.

Migrating a traditional database design to the web can require design modification, additional software, and some added expense.

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

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A widely used method of visualizing and documenting software systems design

At the beginning of the twenty-first century, many firms that used only two digits to represent the year were faced with a major problem called the _____.

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

Most date formats now are based on the model established by the International Organization for Standardization (ISO), which requires a format of _____.

EBCDIC and ASCII both require _____ bits for storage of each character.

A common method of cardinality notation is called _____ because of the shapes, which include circles, bars, and symbols that indicate various possibilities.

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

_____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data.

Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

Emily tells Anna that a primary key is a field or combination of fields that individually and minimally recognizes a specific entity. She mentions that there may be an option of fields or field combinations to use as the primary key. Which of the following is the term used for a feasible primary key?

To bridge the gap between a database and the Internet, it is necessary to use a _____, which is software that integrates different applications and allows them to exchange data.

In a table or file, each column represents a record and each row represents a field.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A set of field values that describes a single person, place, thing, or event

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

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