Question 1

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

Accepted Answer

A)  primary
B)  candidate
C)  foreign
D)  secondaryE) A) and D)
F) C) and D)

Question 2

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 dependencyE) B) and C)
F) A) and B)

Question 3

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

Question 4

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 valuesE) A) and B)
F) B) and C)

Question 5

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)  historicalE) A) and B)
F) A) and C)

Question 6

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 dependencyE) None of the above
F) A) and D)

Question 7

Explain how database designers design and normalize databases.

Accepted Answer

First,an ERD is created through an itera...

Question 8

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 9

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)  fiveE) B) and C)
F) A) and D)

Question 10

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 11

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 normalizingE) All of the above
F) B) and C) A

Question 12

Data redundancy produces .

Accepted Answer

A)  slower lookups
B)  robust design
C)  efficient storage use
D)  data integrity problemsE) B) and D)
F) B) and C)

Question 13

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 14

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 15

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 dependenciesE) A) and B)
F) B) and D)

Question 16

Denormalization produces a lower normal form.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

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

Question 19

Normalization works through a series of stages called normal forms.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False  False

Exam 6: Normalization of Database Tables

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Explain how database designers design and normalize databases.

Correct AnswerverifiedFirst,an ERD is created through an itera...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When designing a database,you should .

Correct AnswerverifiedA

Data redundancy produces .

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Denormalization produces a lower normal form.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

Normalization works through a series of stages called normal forms.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
First,an ERD is created through an itera...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False