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
AS Unit 2 Physics Flashcard Deck
Callum McClintock
Biology Revision - Y10 Mock
Tom Mitchell
3. The Bolshevik's Seizure of Power
ShreyaDas
Of Mice and Men Characters - Key essay points
Lilac Potato
Highway Code Road Signs for Driving Test
Sarah Egan
3.1 Keywords - Marketing
Mr_Lambert_Hungerhil
Biochemistry MCQ Exam 1- PMU 2nd Year
Med Student
2PR101 1.test - 9. část
Nikola Truong
GENERAL PRACTICE-1
Luis Felipe Chávez Choque
Browse Library