Tuesday 3 November 2009

Within this weeks lesson we looked at Normalisation in a deeper aspect, and following the catch-up work I had to do, this session also didnt appear to be to bad. I believe that last week the class only looked at normalising data from only one form, whereas today we looked at normalising data from more than one form at once (e.g. invoice and a purchase order form). The process that was carried out today follows the same stages that were carried out when using Normalisation last week, apart from one more stage is added at the end to remove any repeating entities that occur.

Below are a list of websites that I found that show how normalisation works, and some more information towards how/why the process is useful.
http://www.getahead-direct.com/gwentrel.htm - this website shows how the Entity Relationship diagram can be established once normalisation has being carried out. This website looks as though it could be quite useful to me as I sometimes get confused with the "crows-feet" method.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.admin/db2z_entitynormalization.htm - this website is similar to the first one that I found, as it explains how the different normalisation forms work.
http://www.troubleshooters.com/littstip/ltnorm.html - this website shows another guide for how Normalization works, and the process used to obtain the final results.

No comments:

Post a Comment