Site: http://www.wdvl.com/Authoring/DB/Normalization/ |
| Database Normalization: This web site offers a great tutorial. The author takes you step-by-step through the design of a database using sample data. Using the data in the tables, errors and problems are pointed out. Then, corrections are made before moving on to the next stage of the Normalization process. The author makes the explanations simple, so it is easy to understand and follow. The reader is taken from first normal form all the way through third normal form. At the end, a summary is given, as well as links to other sources the reader can explore for a more detailed explanation of Normalization. |
|
Site: http://cpcug.org/user/access/Presentations/Normalization/index.htm |
| Database Normalization: This website provide defintions about database normalization and a brief description. |
|
Site: http://fiat.gslis.utexas.edu/~l384k11w/normstep.html |
| STEPS IN NORMALIZING A DATABASE: DATABASE-MANAGEMENT PRINCIPLES AND
APPLICATIONS: This website is property of the University of Texas at Austin Graduate School of Library Information Science. This website goes through all of the steps of normalization and gives wonderful examples. It is also easy to read through quickly. This is a website worth checking out. |
|
Site: http://wdvl.com/Authoring/DB/Normalization/ |
| Database Normalization: This is a great reference for database normalization. It basically is like a virtual library. It has anything you want to know about database normalization plus it gives you other references for the topic. |
|
Site: http://cpcug.org/user/access/Presentations/Normalization/index.htm |
| Database Normalization: The website is really a PowerPoint presentation on database normalization and all the topics associated with it. The website is easy to navigate through and nicely organized, most of the terms are defined such as 1NF, 2NF, and 3NF. It explains the relationship that primary keys and have with the 3 levels of normalization and how referential integrity is essential to the process. |
|
Site: http://www.gslis.utexas.edu/~l384k11w/normover.html |
| Overview of Normalization - DATABASE-MANAGEMENT PRINCIPLES AND
APPLICATIONS. This page from THE UNIVERSITY OF TEXAS AT AUSTIN goes over database management principles and applications. It gives a good overview of Normalization. |
|
Site: http://www.troubleshooters.com/littstip/ltnorm.html |
| Normalization Tips: Here you can find tips on normalization that are good to have for reference. They go over 1NF all the way to 3NF. Like I said this is pretty basic
nothing fancy about it. Good thing is it is summarized so that it won't take too much time going over it. |
|
Site: http://datamodel.org/NormalizationRules.html |
| This web page provide an overview of the 5 Rules of Data
Normalization. I recommend this web page if you want a brief review of the the 5 rules of data normalization.
5 rules of data normalization.
1. Eliminate Repeating Groups
2. Eliminate Redundant Data
3. Eliminate Columns Not Dependent On Key
4. Isolate Independent Multiple Relationships
5. Isolate Semantically Related Multiple Relationships |
|
Site: http://wdvl.com/Authoring/DB/Normalization/ |
| Basic Normalization Tutorial: Normalization tutorial by Ian Gilfillan. |
|
Site: http://www.devshed.com/Server_Side/MySQL/Normal/Normal1/page1.html |
| An Introduction to Database Normalization. Database normalization can essentially be defined as the practice of optimizing table structures, which is thoroughly described in this site. |
|
Site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887 |
| SQL By Design: Why you need Database Normalization. I liked this website it gives you information on how to use normalization to help improve system performance and accuracy. It also has information on relationships, primary keys, foreign keys and normal forms. |
|
Site: http://www.devshed.com/Server_Side/MySQL/Normal/ |
| An Introduction to Database Normalization. Very good tutorial. explained in easy to understand terms and examples. If you are having difficulties look no farther. |
|
Site: http://www.gslis.utexas.edu/~l384k11w/normover.html |
| This site lists information on normalization and rules. This is a site for a graduate class at UT. The site contains info on the various normal forms as well as info on the rules of normalization. |
|
Site: http://www.phpbuilder.com/columns/barry20000731.php3 |
| This site has a great step by step approach of going through the levels of
normalization. This site could be very helpful to others. Not only does it have an example problem, but each part of the problem is solved in a
separate step. Also, it tells us of some potential problems with databases that are not normalized. |
|
Site: http://www.datawarehouse.com/iknowledge/articles/article.cfm?ContentID=1846 |
| A Tutorial on Basic Normalization, Part 1. Provides insight that covers normalization from A to Z. Starting with the basic design of a database and its properties, it moves on to the importance of normalization and how the NF rules are applied. |
|
Site: http://www.cba.nau.edu/morgan-j/class/subtop2_3/sld001.htm |
| Normalization Rules for Database Tables. This web site begins by defining what Normalization means and what unnormalized tables are. Normalization is the process for evaluating table structure and recognizing them as needed to product a set of stable, well structured relations. An unnormalized table is a table that does not meet the
definition of a relation. The web site then goes on to list normalization rules for database tables and gives examples. |
|