4035467
Descripción
Mapa Mental por yuroshyini1719, actualizado hace más de 1 año
|
Creado por yuroshyini1719
hace alrededor de 9 años
|
|
Normalization
- Purposes
- organizing of
attributes and
relations
- minimizes data
redundancies
- Issues?
- Delete anomilies
- Deletng critical info
- Deletng critical info
- Update Anomilies
- Update data at
1 table only
- Update data at
1 table only
- Insert Anomilies
- Error when
inserting data
- Error when
inserting data
- Delete anomilies
- Functional
Dependancy
- Partial
- attribute that
depends on a part
of a PK
- occurs when
composite PK exists
- attribute that
depends on a part
of a PK
- Transitive
- a non PK that depends
on another non PK
- a non PK that depends
on another non PK
- Partial
- organizing of
attributes and
relations
- Process
- UNF - 1NF
- eliminate
repeating group
- identify
dependancy
- eliminate
repeating group
- 1NF - 2NF
- remove partial
dependancies
- split tables
- remove partial
dependancies
- 2NF - 3NF
- remove transitive
dependancies
- split tables
again
- remove transitive
dependancies
- UNF - 1NF
¿Quieres crear tus propios Mapas Mentales gratis con GoConqr? Más información.