Please enable JavaScript.
Coggle requires JavaScript to display documents.
Normalisation (Surrogate Key (Artificial Primary Key, Numeric value (Auto…
Normalisation
-
-
2NF
-
-
If 1NF has no composite key, that 1NF is also called 2NF
Transitive Dependency
Has Partial Dependency. (A,B) -> C, D, E, F and A -> C, D
-
A -> C,D and C -> D. A -> D is transitive dependency
-
-
1NF
Table format, no repeating groups, and PK identified
-
-
-
-
Higher of Normalisation, many joins on query
To increase performance, we also do Denormalisation