What follows are some topics important to proper database design. Following these are several examples of database design problems and their solutions.
|
Topics: |
|
|
http://www.rogersaccesslibrary.com/Tutorials/Whatisnormalization.zip - |
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip - http://www.rogersaccesslibrary.com/Tutorials/NormalForms.zip - |
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip - |
http://www.rogersaccesslibrary.com/Tutorials/Unique%20Indexes%20and%20Surrogate%20Keys.doc - |
uploads/5/12-Steps_to_Better_Databases.zip - 12-Steps to Better Databases
|
Examples: |
**Note: The PROCESS is the important thing here. It may be that I have made a mistake in the actual modeling. That will come out in the discussions with the customer and the prototyping. But pay attention to the process that went into the examples. ** |
|
http://www.rogersaccesslibrary.com/Tutorials/ClassInformation.zip - (stores information about students in a college class) |
|
http://www.rogersaccesslibrary.com/Tutorials/CaterItDesign.zip - (small catering business) |
|
http://www.rogersaccesslibrary.com/Tutorials/GSADesign.zip - (Gender Non-specific Scouts of America) |
|
http://www.rogersaccesslibrary.com/Tutorials/ScripDesign.zip - (a high school fund-raising program ) |
|
http://www.rogersaccesslibrary.com/Tutorials/ConsolidatedWidgetsDesign.zip - (stores information for the Widget Trade Show) |
Design Links: |
|
|
-
http://www.databaseanswers.org/data_models/index.htm - Here are some useful 'Kick-Start' Data Models Also, check out these sites:
-
http://www.datamodel.org/NormalizationRules.html - http://support.microsoft.com/default.aspx?scid=kb;en-us;q209534 - http://support.microsoft.com/default.aspx?scid=kb;EN-US;164172 - http://support.microsoft.com/default.aspx?scid=KB;en-us;q234208 -
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041 - Database planning tutorial Part I
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586 - Database planning tutorial Part II
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932 - argeedblu's FAQ on Design Strategies
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208 - Noah's FAQ on Normalization
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=197282 - Jerry's FAQ on Normalization
- http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf - GroverParkGeorge's PDF on Normalization
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=210717 - Jerry’s FAQ on Fully Qualified Naming
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=213518 - Jerry's FAQ on Glossary
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=539419 - Danny's FAQ on Reserved Words
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604 - Autonumbers - What They Are / Are Not
- http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=637301 - Primary Keys - Natural vs Surrogate
- http://support.microsoft.com/kb/q173738 - Naming Conventions - Hungarian Notation
- http://www.utteraccess.com/forums/showflat.php?&Number=1220772 - Crystal's ACCESS Basics for Programming
- http://www.datamodel.org/NormalizationRules.html#one - DataModel.org: Rules of Data Normalization
- http://support.microsoft.com/kb/283878 - MSKB 283878: Description of the database normalization basics
- http://www.mvps.org/access/lookupfields.htm - The Evils of Lookup Fields in Tables
|