Chapter 4.2 : Steps in Normalisation
First normal form (1NF). Any repeating groups have been removed, so that there is a single value at the intersection of each row and column of the table. Second normal form (2NF). Any partial functional dependencies have been removed. Third normal form (3NF). Any transitive dependencies have been removed. Note: If a relation meets the [...]
Chapter 4.1 : Basic Concepts
Normalization is a process for converting complex data structures into simple, stable data structures.Why normalisation is necessary ? The database design must be efficient (performance-wise). The amount of data should be reduced if possible. The design should be free of update, insertion and deletion anomalies. The design must comply with rules regarding relational databases. The [...]
Chapter 4 : Normalization
Chapter Objectives At the end of the chapter, you should be able to: understand the purpose of normalization; perform first, second and third normalization; merging relations (view integration); transforming E-R diagrams to relations. Essential Reading Modem Database Management (4th Edition), red R. Mcfadden & Jeffrey A. Hoffer (1994), Benjamin/Cummings.[Chapter 6, page 199 - 237]
1 Comment