Exam 6: Normalization of Database Tables

A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

It is possible for a table in 2NF to exhibit transitive dependency,where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.

When designing a database,you should .

refers to the level of detail represented by the values stored in a table's row.

A(n)exists when there are functional dependencies such that Y is functionally dependent on X,Z is functionally dependent on Y,and X is the primary key.

Explain how database designers design and normalize databases.

Normalization works through a series of stages called normal forms.For most purposes in business database design,stages are as high as you need to go in the normalization process.

From a system functionality point of view,attribute values can be calculated when they are needed to write reports or invoices.

If a table has multiple candidate keys and one of those candidate keys is a composite key,the table can have based on this composite candidate key even when the primary key chosen is a single attribute.

Data redundancy produces .

BCNF can be violated only if the table contains more than one key.

Normalization works through a series of stages called normal forms.

Dependency diagrams are very helpful in getting a bird's­eye view of all the relationships among a table's attributes.

Denormalization produces a lower normal form.

is a process to help reduce the likelihood of data anomalies.

A table is in 4NF if it is in 3NF,and .

According to the data-modeling checklist,should be nouns that are familiar to business,should be short and meaningful,and should document abbreviations,synonyms,and aliases for each entity.

A dependency based on only a part of a composite primary key is called a (n)_____ .

A(n)exists when there are functional dependencies such that XY is functionally dependent on WZ,X is functionally dependent on W,and XY is the primary key.

In a real-world environment,changing granularity requirements might dictate changes in primary key selection,and those changes might ultimately require the use of __keys.