Find a web site that provides some instruction or assistance to a professional who must normalize a large complicated table into a minimum of 3 N.F.     Post a link to the site that can be used by your colleagues to visit the site and write a sentence or two explaining the value of that sight in this course.  Once a colleague of yours uses a site, you cannot use that link and expect to receive participation credit for a repeated link.

My Link:

An excellent intro into all 3 normal forms of normailzation.

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

Classmates Links:

• http://www.winnetmag.com/Windows/Articles/ArticleID/23745/pg/1/1.html

• "The Database Normalization Process" By:   Ronald Plew, Ryan Stephens www.samspublishing.com/articles/article.asp?p=30646

• Databases: Normalizing Access Data - http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88

• http://support.microsoft.com/kb/q100139/

• Here is one with the now proverbial class table: http://www.serverwatch.com/tutorials/article.php/1549781

• Here is one with a fictional company HR table: http://www.phpbuilder.com/columns/barry20000731.php3

• How to Normalize is an instructional site from Israel - http://www.cs.may.ie/~pmooney/normalization.htm

• This first site is a pdf titled "Normalization is a nice theory". It has alot of good information including an example using the "ACME Software Company". http://www.island-data.com/downloads/papers/normalization.pdf

• The next is a technical paper from FMS. It has an overview which deals with Access. It also has a sample database,

• Sample Database: normalize.zip (22KB), that you can download. http://www.fmsinc.com/tpapers/datanorm/

Send me email

Visit my website