Tuesday, 3 November 2009

Websites for Normalisation and ERDs

Here are a few websites which are helpful when dealing with Normalisation and ERDs.

Normalisation:
http://www.keithjbrown.co.uk/vworks/mysql/mysql_p7.php
This explains the termonology used when normalising data
http://db.grussell.org/section008.html
This website explains in more detail what 0NF, 2NF and 3NF are about and how to do them
http://db.grussell.org/section009.html
Example of normalisation in a row format

ERDs:
http://www.umsl.edu/~sauterv/analysis/er/er_intro.html
Example of an entity relationship diagram
http://www.getahead-direct.com/gwentrel.htm
Online tutorial of how to do an ERD
http://www.mia.org.my/handbook/guide/IMAP/imap7%20Example%20of%20an%20Entity-Relationship%20Diagram.jpg
Example of an entity relationship diagram (2 arrow heads mean 'to many', 1 arrow head means 'one')
http://www.kiwi-dreams.co.nz/wp-content/uploads/2008/12/example-erd1.jpg
A simple example of an ERD (like the one in lecture)
http://www.dcs.bbk.ac.uk/~mark/download/optdb_erd.pdf
Components of ERDs and Examples

Hope these links help!
Sam x

No comments:

Post a Comment