Home arrow MySQL arrow 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.

TABLE OF CONTENTS:
  1. An Introduction to Database Normalization
  2. Preliminary Definitions
  3. So Why Normalize?
  4. The Three Normal Forms
  5. What's Next
By: W.J. Gilmore
Rating: starstarstarstarstar / 234
November 27, 2000

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
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.



 
 
>>> More MySQL Articles          >>> More By W.J. Gilmore
 

blog comments powered by Disqus
   

MYSQL ARTICLES

- Xeround Releases Free Version of MySQL Cloud...
- Oracle Announces New MySQL Specialization
- Constant Contact Chooses SkySQL for MySQL Su...
- Revoke Statement in MySQL
- The Grant Statement in MySQL
- SuccessBricks Announces ClearDB Availability...
- Building a PHP ORM: Deploying a Blog
- TROSYS Launches Free MySQL Manager and Admin...
- Building an ORM in PHP: Domain Modeling
- Building an ORM in PHP
- MySQL Leads Open Source Market, Gets Cluster...
- Oracle Announces Milestone Release for MySQL
- How to Stop SQL Injection Attacks
- New Defragmentation Solution for SQL Server
- Comparison of MyISAM and InnoDB MySQL Databa...


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 3 - Follow our Sitemap

Dev Shed Tutorial Topics: