Data Normalization

Jump to bottom

Nantawan Paramapooti edited this page Nov 10, 2024 · 9 revisions

1-3 NF

Translated UML Relations

Relation()

1NF: All attributes contain only atomic (indivisible) values.

Relation

key1	key2	...

2NF: No partial dependency on any subset of a primary key.

|key||

3NF: No transitive dependency on non-key attributes.

|key||

All these requirements are met through the UML design.