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
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: