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]
Share your thoughts..