Week 5

Question 1

A ____ dependency is where a primary key can determine attributes in the table (when more than 1 attribute is the primary key).

Answer 1

Partial

Question 2

A ____ dependency is where a non-primary key attribute can determine an attribute of another attribute.

Answer 2

Transitive

Question 3

In ______ normalization there cannot be any groupings or null primary key values and all attributes depend on the primary key.

Answer 3

1st

Question 4

In ____ normalization there are no partial dependencies.

Answer 4

2nd

Question 5

In ____ normalization there are no transitive dependencies.

Answer 5

3rd