Database Management Extra 10

Question 1

An attribute that is not part of a key.

Answer 1

Nonprime Attribute

Question 2

A process that assigns attributes to entities so that data redundancies are reduced or eliminated.

Answer 2

Normalization

Question 3

A condition in which an attribute is dependent on only a portion (subset) of the primary key.

Answer 3

Partial Dependency

Question 4

In a relation, a characteristic describing a group of multiple entries of the same type for a single key attribute occurrence. For example, a car can have multiple colors for its top, interior, bottom, trim, and so on.

Answer 4

Repeating Group

Question 5

The ??? ??? in the normalization process, in which a relation is in 1NF and there are no partial dependencies (dependencies in only part of the primary key).

Answer 5

2NF

Question 6

A table is in ??? when it is in 2NF and no nonkey attribute is functionally dependent on another nonkey attribute; that is, it cannot include transitive dependencies.

Answer 6

3NF

Question 7

A condition in which an attribute is dependent on another attribute that is not part of the primary key.

Answer 7

Transitive Dependency

Question 8

The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics.

Answer 8

ALTER TABLE

Question 9

In SQL, a special comparison operator used to check whether a value is within a range of specified values.

Answer 9

BETWEEN

Question 10

A nested ordering sequence for a set of rows, such as a list in which all last names are alphabetically ordered and, within the last names, all first names are ordered.

Answer 10

Cascading Order Sequence