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
134
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
Geometry Formulas
Selam H
UNIT 1 DIGITAL MEDIA SECTORS AND AUDIENCES
carolyn ebanks
French diet and health vocab
caitlindavies8
Camera Angles
saradevine97
OCR Physics P4 Revision
Dan Allibone
GCSE History – Social Impact of the Nazi State in 1945
Ben C
Plant Anatomy Quiz
Kit Sinclair
Carbohydrates
Julia Romanów
1PR101 2.test - Část 15.
Nikola Truong
Browse Library