Question 1

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

Accepted Answer

The answer of An attribute that is part of a...

Question 2

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

Accepted Answer

The answer of The combination of normalization and ER modeling...

Question 3

A table is in BCNF if every determinant in the table is a foreign key.

Accepted Answer

The answer of A table is in BCNF if every...

Question 4

A table that displays data redundancies yields .

Accepted Answer

The answer of A table that displays data redundancies yields...

Question 5

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

Accepted Answer

The answer of From a structural point of view,2NF is...

Question 6

Unnormalized database tables often lead to various data redundancy disasters in production databases.

Accepted Answer

The answer of Unnormalized database tables often lead to various...

Question 7

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.

Accepted Answer

The answer of A(n)exists when there are functional dependencies such...

Question 8

Some very specialized applications may require normalization beyond the .

Accepted Answer

The answer of Some very specialized applications may require normalization...

Question 9

Attributes should clearly define participation,connectivity,and document cardinality.

Accepted Answer

The answer of Attributes should clearly define participation,connectivity,and document cardinality....

Question 10

Normalization represents a micro view of the entities within the ERD.

Accepted Answer

The answer of Normalization represents a micro view of the...

Question 11

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

Accepted Answer

The answer of The advantage of higher processing speed must...

Question 12

A table that has all key attributes defined,has no repeating groups,and all its attributes are dependent on the primary key is said to be in .

Accepted Answer

The answer of A table that has all key attributes...

Question 13

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

Accepted Answer

The answer of Normalization purity is often easy to sustain...

Question 14

Of the following normal forms,is mostly of theoretical interest.

Accepted Answer

The answer of Of the following normal forms,is mostly of...

Question 15

A good relational DBMS excels at managing denormalized relations.

Accepted Answer

The answer of A good relational DBMS excels at managing...

Question 16

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.

Accepted Answer

The answer of Normalization works through a series of stages...

Question 17

Data redundancy produces .

Accepted Answer

The answer of Data redundancy produces .
...

Question 18

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

Accepted Answer

The answer of From a structural point of view,3NF is...

Question 19

Attribute A attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Accepted Answer

The answer of Attribute A attribute B if all of...

Question 20

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

Accepted Answer

The answer of A table is in fourth normal form...

Quiz 6: Normalization of Database Tables

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