CODEWITHSUNDEEP
database-normalization
BxtchCraft
BxtchCraft

Reputation: 488

1NF - 3NF deal with functional dependency. What does BCNF - 5NF deal with?

I read somewhere that 1NF - 3NF deal with functional dependency, and that the Higher Normal Forms focus on another aspect of database relationships, but I can't remember what. Does anyone know the answer to this?

1NF - 3NF deal with function dependency. BCNF - 5NF deal with ______?

My best educated guess is non-tivial / multivalued dependencies.

Is that correct, or am I way off base?

Upvotes: 1

Views: 153

Answers (1)

Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'

Reputation: 95582

BCNF deals with functional dependencies.

4NF deals with multivalued dependencies.

5NF deals with join dependencies. 6NF deals with join dependencies in a more general way.

Upvotes: 2

Related Questions