Exam 9: Data Design

Because it supports virtually all languages, ____________________ has become a global standard.

____________________ codes distinguish items by using a series of subgroups of digits.

Four kinds of problems are found with 1NF designs that do not exist in 2NF. What are they?

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

MATCHING Identify the letter of the choice that best matches the phrase or definition.a.UML f.subschema b.cardinality g.EBCDIC c.secondary key h.entity d.data mining i.physical e.orphan j.logical -Kind of storage that is strictly hardware-related, because it involves the process of reading and writing binary data to physical media.

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

Three main types of relationships that can exist between entities are a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

MATCHING Identify the letter of the choice that best matches the phrase or definition.a.UML f.subschema b.cardinality g.EBCDIC c.secondary key h.entity d.data mining i.physical e.orphan j.logical -A person, place, thing, or event for which data is collected and maintained.

Web-based data design requires users to have powerful workstations.

Malia asks if it is possible to retrieve records using a field or combination of fields that is not unique. Michelle informs her that it is. What is the name for this type of key?

Computers represent data as ____________________ that have only two possible values: zero (0) or one (1).

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

Binary digits have only ____ possible value(s).

In a Web-based database design, the Internet serves as the ____ for the database management system.

In the event of a file catastrophe, ____ can be used to restore the file or database to its current state at the time of the last backup.

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition.a.UML f.subschema b.cardinality g.EBCDIC c.secondary key h.entity d.data mining i.physical e.orphan j.logical -A coding method used on mainframe computers and high-capacity servers.

MATCHING Identify the letter of the choice that best matches the phrase or definition.a.UML f.subschema b.cardinality g.EBCDIC c.secondary key h.entity d.data mining i.physical e.orphan j.logical -A field or combination of fields that can be used to access or retrieve records.

Migrating a traditional database design to the Web rarely requires design modification or additional software.

JDBC is the language of the Web. _________________________