Question 1

Because a partial dependency can exist only if a table's primary key is composed of several attributes,a table whose ____________________ key consists of only a single attribute is automatically in 2NF if it is in 1NF.

Accepted Answer

The answer of Because a partial dependency can exist only...

Question 2

According to the Data-Modeling Checklist,____________________ should be nouns that are familiar to business and 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...

Question 3

In _________________________,no row may contain two or more multivalued facts about an entity.

Accepted Answer

The answer of In _________________________,no row may contain two or...

Question 4

The combination of ____________________ and ER modeling yields a useful ERD,whose entities may now be translated into appropriate table structures.

Accepted Answer

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

Question 5

The problem with transitive dependencies is that they still yield data ____________________.

Accepted Answer

The answer of The problem with transitive dependencies is that...

Question 6

It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.

Accepted Answer

The answer of It becomes difficult to create a suitable...

Question 7

Explain the BCNF.How is it related to other normal forms?

Accepted Answer

The answer of Explain the BCNF.How is it related to...

Question 8

Explain normalization and its different forms.

Accepted Answer

The answer of Explain normalization and its different forms....

Question 9

All relational tables satisfy the ____________________ requirements.

Accepted Answer

The answer of All relational tables satisfy the ____________________ requirements....

Question 10

An attribute that cannot be further divided is said to display ____________________.

Accepted Answer

The answer of An attribute that cannot be further divided...

Question 11

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 12

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

Accepted Answer

The answer of When a nonkey attribute is the determinant...

Question 13

Describe a dependency diagram and explain its purpose.

Accepted Answer

The answer of Describe a dependency diagram and explain its...

Question 14

The ____________________ provides the big picture,or macro view,of an organization's data requirements and operations.

Accepted Answer

The answer of The ____________________ provides the big picture,or macro...

Question 15

A diagram that depicts all dependencies found within a given table structure is known as a(n)____________________.

Accepted Answer

The answer of A diagram that depicts all dependencies found...

Question 16

Any attribute whose value determines other values within a row is called a(n)____________________.

Accepted Answer

The answer of Any attribute whose value determines other values...

Question 17

Data redundancies occur from ____________________ of data on every row entry.

Accepted Answer

The answer of Data redundancies occur from ____________________ of data...

Question 18

Explain how database designers design and normalize databases.

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of What steps are involved in the conversion...

Question 20

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

Quiz 6: Normalization of Database Tables