A quick guide to the basics of database normalization—a critical step in refreshing an older IBM i database
by Rafael Victoria-Pereira
Editor's note: This article is excerpted from chapter 5 of SQL for IBM i: A Database Modernization Guide, by Rafael Victoria-Pereira.
Most people take a quick look at the normal forms definitions—the “steps” to achieve normalization Nirvana—and dismiss the whole thing as being an academic and convoluted waste of time. Actually, normalization is, for the most part, easy and mostly common sense with some business knowledge thrown in. Once you understand the fundamental concepts, you’ll see that it’s useful and a great way to tackle aging and “broken” databases. Let me start by introducing a few key concepts that will be used later to define each normal form.