CIS4365: Database Applications
Fall, 2017

Normalization

All Submissions are recorded here. If there are Duplicate submissions (of sites), all sets of comments are recorded. If the submitter wishes to give their name, it is noted.

Site: http://www.wdvl.com/Authoring/DB/Normalization/ 
bulletDatabase 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
bulletDatabase Normalization: This website provide defintions about database normalization and a brief description.
Site: http://fiat.gslis.utexas.edu/~l384k11w/normstep.html
bulletSTEPS 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/
bulletDatabase 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
bulletDatabase 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
bulletOverview 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
bulletNormalization 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
bulletThis 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/
bulletBasic Normalization Tutorial: Normalization tutorial by Ian Gilfillan.
Site: http://www.devshed.com/Server_Side/MySQL/Normal/Normal1/page1.html
bulletAn 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
bulletSQL 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/
bulletAn 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
bulletThis 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
bulletThis 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
bulletA 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
bulletNormalization 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.

 

                                                                                This page was last updated on 08/18/03