null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
4035467
Normalization
Description
Mind Map on Normalization, created by yuroshyini1719 on 14/11/2015.
No tags specified
yuro
shy
ini
Mind Map by
yuroshyini1719
, updated more than 1 year ago
More
Less
Created by
yuroshyini1719
over 8 years ago
136
0
0
Resource summary
Normalization
Purposes
organizing of attributes and relations
minimizes data redundancies
Issues?
Delete anomilies
Deletng critical info
Update Anomilies
Update data at 1 table only
Insert Anomilies
Error when inserting data
Functional Dependancy
Partial
attribute that depends on a part of a PK
occurs when composite PK exists
Transitive
a non PK that depends on another non PK
Process
UNF - 1NF
eliminate repeating group
identify dependancy
1NF - 2NF
remove partial dependancies
split tables
2NF - 3NF
remove transitive dependancies
split tables again
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Adjectives
Dhoha Alsaadi
1_Adjectives
Dhoha Alsaadi
Mind Maps Essay Template
linda_riches
Weimar Germany 1919: The Spartacists and the constitution
Chris Clayton
Plant and animal cells
charlotteireland
AQA GCSE Physics Unit 2.7
Matthew T
Chemistry GCSE
frimpongr
The Rise of the Nazis
shann.w
Trigonometry, Equations, Pythagoras theorem
Caitlin Mortlock
Psychology Key Words Research Methods
Alfie Moorhead
Mezinárodní ekonomie 2SE221,2SE201 (1)
Filip Wimmer
Browse Library