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

Adjectives

Dhoha Alsaadi

Copy and Edit

Normalization

Description

Mind Map on Normalization, created by yuroshyini1719 on 14/11/2015.

Mind Map by yuroshyini1719, updated more than 1 year ago

	Created by yuroshyini1719 over 9 years ago

158

(0)

Resource summary

Normalization

Purposes
1. organizing of attributes and relations
2. minimizes data redundancies
3. Issues?
  1. Delete anomilies
    1. Deletng critical info
  2. Update Anomilies
    1. Update data at 1 table only
  3. Insert Anomilies
    1. Error when inserting data
4. Functional Dependancy
  1. Partial
    1. attribute that depends on a part of a PK
    2. occurs when composite PK exists
  2. Transitive
    1. a non PK that depends on another non PK
Process
1. UNF - 1NF
  1. eliminate repeating group
  2. identify dependancy
2. 1NF - 2NF
  1. remove partial dependancies
  2. split tables
3. 2NF - 3NF
  1. remove transitive dependancies
  2. split tables again

Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

To join the discussion, please sign up for a new account or log in with your existing account.

Want to create your own Mind Maps for free with GoConqr? Learn more.

Similar

1_Adjectives

Dhoha Alsaadi

Atoms, Protons, Neutrons & Electrons quiz

leonie.examtime

American Football

jackmackinder19

GCSE Maths Quiz

Andrea Leyden

Meriya Pinales & Malika Hurt

hurtmalika

A2 Level Biology: Transcription & Translation

Ollie O'Keeffe

Othello content knowledge quiz

rubyduggan

Geography - Restless Earth

pip.kaley

Phrasal Verbs

Felipe Veintimilla

Biological molecules

Georgia Battersby-Hill

Browse Library