module 6 review questions

Question 1

it should already be in the First Normal form and it should not have Partial Dependency (or they are eliminated).

Answer 1

When is a table in 2NF?

Question 1

When all of the key attributes are defined and they are single valued. There should be no repeating groups of data within a single row.

Answer 1

When is a table in 1NF?

Question 2

A table is in ____if 1) it is already in Second Normal Form (2NF), and 2) there are no transitive dependencies for non-prime attributes

Answer 2

When is a table in 3NF?

Question 3

A table is in ____normal form when it is in ______and there are no transitive dependencies.

Answer 3

3NF; 2NF

Question 4

How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?

Answer 4

transitive dependency

Question 5

A _____________is an indirect relationship between values in the same table that causes a functional dependency.

Answer 5

transitive dependency

Question 6

What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?

Answer 6

Update anomalies, addition anomalies, and deletion anomalies.

Question 7

Why is a table whose primary key consists of a single attribute automatically in 2NF when it is in 1NF?

Answer 7

Because there will be no partial dependencies.