Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data (Databases (Normalisation
Improving data so it can be searched,…
Data
Databases
-
-
Normalisation
Improving data so it can be searched, sorted or filtered
ONF -> INF -> 2NF -> 3NF
NF = normal form
-
1NF
- Get rid of repeating data
-
- Get rid of duplicate columns
- Separate not "atomic" attributes into separate attributes
2NF
-
- Fix many to many relationships
-
-
-
-
Databases are structures,persistent collection of data.
Composite Key:
A combination of two or more columns in a table
that can be used to uniquely identify each row in the table
Flat Files
A spreadsheet
A table
A grid of data
CSV, XCS
-
-
-