4035467
Description
Mind Map by yuroshyini1719, updated more than 1 year ago
|
Created by yuroshyini1719
about 9 years ago
|
|
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
Want to create your own Mind Maps for free with GoConqr? Learn more.