Your coach is here to assist
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
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