88066
Description
Mind Map by Fiona Faulkner, updated more than 1 year ago
|
Created by Fiona Faulkner
over 11 years ago
|
|
NORMALISATION
- 1NF
- All data is atomic
- Has a PK
- No repeating data/fields
- unique field names
- All data is atomic
- 2NF
- Already in 1NF
- All non-key fields are dependent on the whole PK
- all field data can be found by
looking at entire PK
- all field data can be found by
looking at entire PK
- Already in 1NF
- 3NF
- table is already in 2NF
- No functional dependency between
non-key fields
- table is already in 2NF
- ADVANTAGES
- increased data integrity -
only 1 copy so correct
- flexibility for
expanding
database in future
- easier to
maintain
database
- less storage space needed,
so smaller hard drive
- increased data integrity -
only 1 copy so correct
- DISADVANTAGES
- reduces database
performance - more
tables=slower processing
- results of historial
calculations can't be
stored
- may not meet needs of
comapny, e.g. store
address as 1 field
- reduces database
performance - more
tables=slower processing
Want to create your own Mind Maps for free with GoConqr? Learn more.