88066
Descripción
Mapa Mental por Fiona Faulkner, actualizado hace más de 1 año
|
Creado por Fiona Faulkner
hace más de 11 años
|
|
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
¿Quieres crear tus propios Mapas Mentales gratis con GoConqr? Más información.