Please enable JavaScript.
Coggle requires JavaScript to display documents.
Normalisation - Coggle Diagram
Normalisation
The Normalisation Process
Avoidance of Modification Anomalies
modification anomalies
insertion anomalies
added to the database
update anomalies
it is necessary to change multiple rows
deletion anomalies
data to be deleted
The First Normal Form
not contain repeating groups
The Third Normal Form
prohibits transitive dependencies
The Second Normal Form
primary key determine the nonkey columns
The Functional Dependencies
minimize data redundancies
the concept of determination
types
partial dependency
transitive dependency