HomeMySQL Page 5 - An Introduction to Database Normalization
What's Next - MySQL
A database can be great fun, right? Yes, of course!There are though, a couple things that can ruin allthat hard work and effort you put into your efficient little database. Today we discuss how to keep that beloved bin of data from going bad on you: databasenormalization.
Taking time to properly design your database is arguably the most important step in developing database-oriented applications. This article focused upon informing you of the basic premises of efficient db design, introducing database normalization, general definitions, and the first three Normal Forms. Next article, Iíll focus upon applying these principles to a MySQL database, introducing you to the syntax necessary to make database normalization possible. Iíll also illustrate how SQL queries can then be used to mine the normalized tables for useful information. If you canít wait to learn more about how queries are used to retrieve data from normalized tables, I would suggest checking out the Devshed article MySQL Table Joins.