Chapter 4

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

True

False

A cascading delete removes all records in other tables associated with the record to be deleted.

True

False

A constraint between two attributes is called a(n):

Functional relation

Attribute dependency

Functional dependency

Functional relation constraint

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

True

False

A functional dependency between two or more nonkey attributes is called a:

Partial functional dependency

Partial nonkey dependency

Transitive dependency

Partial transitive dependency

A primary key is an attribute that uniquely identifies each row in a relation.

True

False

A primary key that consists of more than one attribute is called a:

Foreign key

Composite key

Multivalued key

Cardinal key

A primary key whose value is unique across all relations is called a(n):

Global primary key

Inter-table primary key

Enterprise key

Foreign global key

A relation is in first normal form if it has no more than one multivalued attribute.

True

False

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

First

Second

Third

Fourth

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Referential integrity constraint

Key match rule

Entity key group rule

Foreign/primary match rule

A two-dimensional table of data sometimes is called a:

Group

Set

Declaration

Relation

All of the following are the main goals of normalization EXCEPT:

Minimize data redundancy

Simplify the enforcement of referential integrity

Maximize storage space

Make it easier to maintain data

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Link attribute

Link key

Foreign key

Foreign attribute

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Column

Foreign field

Primary key

Duplicate key

In the figure below, the primary key for "Order Line" is which type of key?

Composite

Foreign

Standard

Grouped

In the figure below, what type of relationship do the relations depict?

Strong entity/weak entity

One-to-many

Ternary

Many-to-many

The allowable range of values for a given attribute is part of the domain constraint.

True

False

The columns of a relation can be interchanged without changing the meaning or use of the relation.

True

False

The normal form which deals with multivalued dependencies is called:

Fifth normal form

Fourth normal form

Boyce-codd normal form

Sixth normal form

Chapter 4

More Quizzes