8 - Dependencies

What is a partial dependency?

• When a non-prime attribute depends on the whole composite primary key

• When a non-prime attribute depends on part of a composite primary key

• When a non-prime attribute depends on another non-prime attribute

• When all attributes are fully dependent on the primary key

Which normal form eliminates partial dependencies?

• 1NF

• 2NF

• 3NF

• 4NF

In which situation does a partial dependency occur?

• When a non-key attribute depends on the primary key

• When a non-key attribute depends only on part of a composite primary key

• When a non-key attribute depends on another non-key attribute

• When a non-key attribute depends on the entire composite key

What is a transitive dependency?

• When a non-key attribute depends on part of a composite key

• When a non-key attribute depends on another non-key attribute

• When a key attribute depends on another key attribute

• When a non-key attribute depends on the whole composite primary key

Which normal form eliminates transitive dependencies?

• 1NF

• 2NF

• 3NF

• 4NF

Which of the following is an example of a partial dependency?

• A non-prime attribute depends on part of a composite key

• A non-prime attribute depends on a non-prime attribute

• A non-prime attribute depends on the entire composite key

• A candidate key depends on another candidate key

In order to remove partial dependencies, a table must be converted into:

• 1NF

• 2NF

• 3NF

• 4NF

Which of the following is an example of a transitive dependency?

• A non-prime attribute depends on the whole composite primary key

• A non-prime attribute depends on another non-prime attribute

• A non-prime attribute depends on part of a composite primary key

• A non-prime attribute depends on a foreign key

In which normal form must a table be if it has no partial or transitive dependencies?

• 1NF

• 2NF

A table with a composite primary key has a non-prime attribute that depends on only one part of the key. What type of dependency is this?

• Transitive dependency

• Partial dependency

• Functional dependency

• Multi-valued dependency