Print Page | Close Window

Database Design

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Tutorials
Forum Description: Roger's Database and Application Design Tutorials
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=238
Printed Date: 23 May 2017 at 10:45am


Topic: Database Design
Posted By: Roger Carlson
Subject: Database Design
Date Posted: 20 Jul 2008 at 11:01pm

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


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window