Database Normalization Resources

The hardest thing to do when building any database is in understanding what tables to create and what needs to go in each one. This has nothing to do with learning to use Access. The easiest object to create in Access is a table. The Access Table designer is very easier to use. If you have a good working knowledge of good database design and the rules of data normalization then it makes learning to work with Access or any database development platform much easier.

 The goals of database normalization, include:

  • Free the database of modification anomalies
  • Minimize redesign when extending the database structure
  • Make the data model more informative to users
  • Avoid bias towards any particular pattern of querying

For additional information on database Normalization see:

Wikipedia - Database  Normalization

Rules of Data Normalization

by FMS Inc.
Microsoft Access and SQL Server Database Normalization Tips
Microsoft Access Data Normalization Fundamentals

by Michael Hernandez:

Understanding Normalization PDF
Database Design Tips.zip

ACC: Database Normalization Basics
http://support.microsoft.com/?id=100139
http://support.microsoft.com/?id=209534
http://support.microsoft.com/?id=283878

Where to find information about designing a database in Microsoft Access:
http://support.microsoft.com/?id=289533

"Understanding Relational Database Design" Document Available in Download Center:
http://support.microsoft.com/?id=283698
http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"
http://support.microsoft.com/?id=234208

Fundamentals of Relational Database Design:
http://support.microsoft.com/?id=129519

http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Data Normalization Fundamentals by Luke Chung:
http://www.fmsinc.com/tpapers/datanorm/index.html

Support WebCast: Database Normalization Basics
http://support.microsoft.com/default.aspx?scid=/servicedesks/
webcasts/wc060600/wcblurb060600.asp

Concepts Of Database Design And Management:
http://www.sitepoint.com/article/database-design-management

Database Design And Normalization (aimed at dBase, but still valid):
http://www.jpmartel.com/bu12_c.htm

Database Normalization:
http://burks.bton.ac.uk/burks/foldoc/35/28.htm

Introduction To Data Modeling:
http://www.utexas.edu/its/windows/database/datamodeling/index.html

Normalization Rules - Beyond The Third Normal Form
http://www.curlingstone.com/Normalization2.html

Normalization:
http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/contents.html

Normalization:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html

Advanced Normalization:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html

Overview of Normalization:
http://www.gslis.utexas.edu/~wyllys/DMPAMaterials/normover.html

Normalization:
http://db.grussell.org/section008.html

Normalization – BCNF:
http://db.grussell.org/section009.html

A Simple Guide to Five Normal Forms in Relational Database Theory:
http://www.bkent.net/Doc/simple5.htm

Introduction to Relational Databases - Part 1: Theoretical Foundation:
http://www.15seconds.com/issue/020522.htm

On DK/NF Normal Form:
http://www.dbdebunk.com/page/page/621935.htm