Copy and Edit

Normalization

Description

Mind Map on Normalization, created by yuroshyini1719 on 14/11/2015.
yuroshyini1719
Mind Map by yuroshyini1719, updated more than 1 year ago
yuroshyini1719
Created by yuroshyini1719 about 10 years ago
164
0
0

Resource summary

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