Question 1

Explain normalization and its different forms.

Accepted Answer

Normalization is a process for evaluatin

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

The price paid for increased performance through denormalization is a larger amount of ____________________.

Accepted Answer

redundancy

Question 5

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)  has no multivalued dependencies 
D)  no column contains the same values 
A)  all attributes must be dependent on the primary key, and must be dependent on each other 
B)  all attributes are unrelated 
C)  has no multivalued dependencies 
D)  no column contains the same values

Question 6

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 7

Normalization is a very important database design ingredient and the highest level is always the most desirable.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

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

Question 10

In a real-world environment, we must strike a balance between design integrity and ____.

Accepted Answer

A)  robustness 
B)  flexibility 
C)  uniqueness 
D)  ease of use 
A)  robustness 
B)  flexibility 
C)  uniqueness 
D)  ease of use

Question 11

When designing a database, you should ____.

Accepted Answer

A)  make sure 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)  make sure 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

Question 12

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

Accepted Answer

A)  1NF 
B)  3NF 
C)  BCNF 
D)  DKNF 
A)  1NF 
B)  3NF 
C)  BCNF 
D)  DKNF

Question 13

A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.

Accepted Answer

A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF 
A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF

Question 14

Atomic attributes are attributes that can be further subdivided.

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

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

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

Question 17

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 Form 
B)  redundancy 
C)  time-variance 
D)  partial dependencies 
A)  Boyce-Codd Normal Form 
B)  redundancy 
C)  time-variance 
D)  partial dependencies

Question 18

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

Question 19

With partial dependencies, data redundancies occur because every row entry requires duplication of data.

Accepted Answer

A) True 
 B)False

Question 20

A table that is in 1NF and includes no partial dependencies is said to be in ____.

Accepted Answer

A)  BCNF 
B)  2NF 
C)  3NF 
D)  4NF 
A)  BCNF 
B)  2NF 
C)  3NF 
D)  4NF

Explain normalization and its different forms.

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

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

The price paid for increased performance through denormalization is a larger amount of ____________________.

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

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

Normalization is a very important database design ingredient and the highest level is always the most desirable.

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.

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

In a real-world environment, we must strike a balance between design integrity and ____.

When designing a database, you should ____.

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

A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.

Atomic attributes are attributes that can be further subdivided.

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

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.

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.

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

With partial dependencies, data redundancies occur because every row entry requires duplication of data.

A table that is in 1NF and includes no partial dependencies is said to be in ____.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 9: Normalizing Database Designs

Explain normalization and its different forms.

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

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

The price paid for increased performance through denormalization is a larger amount of ____________________.

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

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

Normalization is a very important database design ingredient and the highest level is always the most desirable.

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.

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

In a real-world environment, we must strike a balance between design integrity and ____.

When designing a database, you should ____.

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

A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.

Atomic attributes are attributes that can be further subdivided.

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

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.

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.

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

With partial dependencies, data redundancies occur because every row entry requires duplication of data.

A table that is in 1NF and includes no partial dependencies is said to be in ____.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters