4035467
Descrição
Mapa Mental por yuroshyini1719, atualizado more than 1 year ago
|
Criado por yuroshyini1719
aproximadamente 9 anos atrás
|
|
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
Quer criar seus próprios Mapas Mentais gratuitos com a GoConqr? Saiba mais.