4035467
Beschreibung
Mindmap von yuroshyini1719, aktualisiert more than 1 year ago
|
Erstellt von yuroshyini1719
vor etwa 9 Jahre
|
|
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
Möchten Sie kostenlos Ihre eigenen Mindmaps mit GoConqr erstellen? Mehr erfahren.