Exam 9: Data Design

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A technique used by analysts to define relationships in more detail, after drawing an initial entity-relationship diagram

A _____, which is a framework for organizing, storing, and managing data, consists of files or tables that interact in various ways.

A table is in _____ if it does not contain a repeating group.

_____ use a keyword to encode a number.

During the systems design phase, _____ are used to organize, access, and maintain data structures.

A combination key can also be called a _____.

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.

A(n) _____ is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data.

A table design that contains a repeating group is called _____.

-In the accompanying figure, a _____ is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables.

-In the accompanying figure, any field that serves as a primary key is called a _____.

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

The data mining technique that relies on association rule learning is often called _____.

Compared with character-based formats, a _____ offers a more efficient storage method.

Binary digits have only _____ possible value(s).

A _____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

Eamon plans to operate three warehouses, in different cities, to support his business. To find the exact location of a product, he wants to establish a code that identifies a product's warehouse location, floor number, section number, aisle number, and bin number. By doing this, he can ship the ordered products faster. Which of the following codes would you suggest Eamon to use?

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A person, place, thing, or event for which data is collected and maintained

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

A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on one another.