[Year 12 IT Apps] Normalisation

[Robert Timmer-Arends]

Hello Mark and others

One of the concerns I have about these normalisation discussions is that there appear to be a lot of issues conflated into a single word 'normalisation', hence not leading to clear answers.
For example, when one says 'a clear and logical way to explain normalisation' does one mean:
- explain what normalisation is
- explain why normalisation is needed
- explain how to recognise when a set of tables is (is not) normalised
- explain what the normal forms are
- explain how to arrive at each normal form
- explain why each normal form is defined the way it is (what it is trying to prevent/achieve)
etc

Regards
Robert T-A
  ----- Original Message ----- 
  From: Mark 
  To: Year 12 IT Applications Teachers' Mailing List 
  Sent: Thursday, April 23, 2015 1:36 PM
  Subject: Re: [Year 12 IT Apps] Normalisation


  ... slides which I'm still trying to get right.  :-o


  I keep trying to find a clear and logical way to explain normalisation, but never quite get there.
  Just be thankful we only need to get to 3NF, and not 5NF.


  Arghh!




  On 23 April 2015 at 13:24, Laurie Savage <08327998 at pvgc.vic.edu.au> wrote:

    I guess you have shown them Mark Kelly's wonderful slides?


    Laurie



    Laurie Savage


    On 23 April 2015 at 11:34, Sylvia Pastore <smp191172 at gmail.com> wrote:

      Hi all,
      Would anyone have any tasks relating to normalisation that they are willing to share, my kids need more practise.


      Thanks

      _______________________________________________
      http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
      IT Applications Mailing List kindly supported by
      http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
      http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
      http://www.swinburne.edu.au/ict/schools - Swinburne University




    _______________________________________________
    http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
    IT Applications Mailing List kindly supported by
    http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
    http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
    http://www.swinburne.edu.au/ict/schools - Swinburne University






  -- 



  >> Witty sig goes HERE <<


  Mark Kelly
  mark AT vceit DOT com
  http://vceit.com






------------------------------------------------------------------------------


  _______________________________________________
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
  IT Applications Mailing List kindly supported by
  http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
  http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
  http://www.swinburne.edu.au/ict/schools - Swinburne University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20150423/15ec7a27/attachment-0001.html