LESSON-10 A CASE FOR NORMALIZATION (Cont’d; Ashraf, Khan, and Mir) Posted on September 22, 2012

LESSON-10 A CASE FOR NORMALIZATION (Cont’d; Ashraf, Khan, and Mir)

Posted on September 22, 2012

https://be4gen.wordpress.com/2012/09/22/lesson-10-a-case-for-normalization-contd-ashraf-khan-and-mir/by be4gen

LESSON-10  A CASE FOR NORMALIZATION  (Cont’d; Ashraf, Khan, and Mir) 

10.1 Review

Normalization processes of entities are means of finding out functional dependencies among the attributes of entities. The fully normalized database is obtained by elimination of potential functional redundancies when there multiple, composite, overlapping candidate keys. This is accomplished by converting files of 0nf, 1nf, 2nf, 3nf, BCNF, 4nf, 5nf as much necessary.

In transactional databases the commonly required normalization levels are 1nf, 2nf, and 3f. See a case going through those steps.

*****

 MESSAGE: DEDICATED TO ANONYMOUS COMBATANTS OF KNOWLEDGE

مکتب علم الل مہد منل لحد   Learning continues from birth to death

FOR PROMOTION OF LEARNEDNESS SHARE WITH FRIENDS ABOUT;

   

1. CAUSE AND EVENTS – SPATIAL And TEMPORAL RESPECTIVELY:                         https://be4gen.wordpress.com/2012/11/16/cause-and-events-spatial-temporal-respectively/

1. WHETHER ‘BRAIN-POWER’ OR ‘HEART-IMPULSE’ PLINTHS ‘HUMAN GEN’? http://sunedu.wordpress.com/2012/09/17/whether-brain-power-or-heart-impulse-plinths-human-gen/

************

Related