Exam 6: Normalization of Database Tables

Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

In a(n)diagram,the arrows above the attributes indicate all desirable dependencies.

When designing a new database structure based on the business requirements of the end users,the database designer will construct a data model using a technique such as .

The combination of normalization and ER modeling yields a useful ERD,whose entities can be translated into appropriate relationship structures.

What steps are involved in the conversion to third normal form?

From a structural point of view,2NF is better than .

Normalization is a very important database design ingredient,and the highest level is always the most desirable.

An attribute that is part of a key is known as a(n)attribute.

Normalization purity is often easy to sustain in the modern database environment.

In a real-world environment,we must strike a balance between design integrity and .

From a structural point of view,3NF is better than .

Any attribute that is at least part of a key is known as a (n)_____ .

databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

In a situation,one key determines multiple values of two other attributes and those attributes are independent of each other.

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

Any attribute whose value determines other values within a row is known as a .

Data redundancy produces data anomalies.

When a nonkey attribute is the determinant of a key attribute,the table is in 3NF but not in .

A table that displays data redundancies yields .

An ERD is created through a (n)________ process.