Exam 9: Data Design

In a table or file, each column represents a record, which is an individual instance, or occurrence of an entity, and each row represents a field, or characteristic of the entity.

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

____ codes are numbers or letters assigned in a specific order.

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 refers to information as seen through a user's eyes, regardless of how or where the information actually is organized or stored.

Perry mentions that some data in a file processing system may be repeated in several different files. What is the name of this type of problem?

A primary key cannot be composed of more than one field.

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

All system files and databases must be backed up regularly and a series of ____________________ copies must be retained for a specific period of time.

An integer format uses ____ bits to represent the number 12,345 in binary form.

A popular rule of thumb is that a design is in 3NF if every nonkey field depends on the key, the whole key, and nothing but the key.

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

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

A data warehouse allows users to specify certain dimensions, or characteristics.

A ____ contains data about people, places, things, or events.

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 on part of the primary key.

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 foreign key value that does not match an existing key in another table.

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 view of a database used by one or more systems or users.

A(n) ____________________ date is the total number of days from some specific base date.

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.