Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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.

Accepted Answer

A) True 
 B)False  True

Question 3

When designing a database,you should .

Accepted Answer

A)  make sure that entities are in normal form before table structures are created
B)  create table structures then normalize the database
C)  only normalize the database when performance problems occur
D)  consider more important issues such as performance before normalizing A

Question 4

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

Accepted Answer

The answer of refers to the level of detail represented...

Question 5

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.

Accepted Answer

A)  partial dependency
B)  repeating group
C)  atomic attribute
D)  transitive dependency

Question 6

Explain how database designers design and normalize databases.

Accepted Answer

The answer of Explain how database designers design and normalize...

Question 7

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

A)  two
B)  three
C)  four
D)  five

Question 8

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

Accepted Answer

A)  derived
B)  atomic
C)  granular
D)  historical

Question 9

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.

Accepted Answer

A)  Boyce-Codd normal forms
B)  redundancies
C)  time-variances
D)  partial dependencies

Question 10

Data redundancy produces .

Accepted Answer

A)  slower lookups
B)  robust design
C)  efficient storage use
D)  data integrity problems

Question 11

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

Accepted Answer

A)  primary
B)  candidate
C)  foreign
D)  secondary

Question 12

Normalization works through a series of stages called normal forms.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Denormalization produces a lower normal form.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The answer of is a process to help reduce the...

Question 16

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

Accepted Answer

A)  all attributes must be dependent on the primary key and must be dependent on each other
B)  all attributes are unrelated
C)  it has no multivalued dependencies
D)  no column contains the same values

Question 17

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.

Accepted Answer

The answer of According to the data-modeling checklist,should be nouns...

Question 18

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

Accepted Answer

The answer of A dependency based on only a part...

Question 19

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

A)  atomic attribute
B)  repeating group
C)  partial dependency
D)  transitive dependency

Question 20

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.

Accepted Answer

The answer of In a real-world environment,changing granularity requirements might...

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'seye 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.

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.

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