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
142
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
Economics definitions: F582
busybee112
GENDER OF SPANISH NOUNS
differentiated4u
Biology Unit 2 - DNA, meiosis, mitosis, cell cycle
DauntlessAlpha
Maths C4 Trig formulae (OCR MEI)
Zacchaeus Snape
A2 Ethics - Virtue Ethics
Heloise Tudor
Cell Structure
megan.radcliffe16
Meiosis vs. Mitosis
nvart00
Development of Cold War Tensions
c7jeremy
No more diets
amna mohd
Browse Library