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

156

(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

Command Words

Mr Mckinlay

Unit 3 Business Studies

Lauren Thrower

The Effects of Climate Change

j. stu

The structure of the heart

rachel_w

Lesson Planning: 4 Organisational Tips for Teachers

miminoma

Using GoConqr to teach English literature

Sarah Egan

Flame tests

Joshua Rees

I wish I..

Cristina Cabal

2_PSBD HIDDEN QUS By amajad ali

Ps Test

Browse Library