[Year 12 IT Apps] Normalisation practical exercises for exam revision

[Watson, Donald R]

Supplementary materials.

Don

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Chris Morgan
Sent: Thursday, 22 October 2015 9:59 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Normalisation practical exercises for exam revision

Hi all – just doing some revision with my students (as I’m sure we all are) – I’d LOVE to find some practical exercises to work through to hone our normalisation skills. Yep, I know there are the questions on the previous years’ exams, however that’s only a few….anybody know of some or can suggest where I might look?

Thanks Chris

From: itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Robert Timmer-Arends
Sent: Thursday, 23 April 2015 6:12 PM
To: Year 12 IT Applications Teachers' Mailing List <itapps at edulists.com.au<mailto:itapps at edulists.com.au>>
Subject: Re: [Year 12 IT Apps] Normalisation

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<mailto:mark at vceit.com>
To: Year 12 IT Applications Teachers' Mailing List<mailto:itapps at edulists.com.au>
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<mailto: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<mailto: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


################################################################################
This e-mail and any attached files are confidential and intended solely for the person to whom it is addressed. If you have received this e-mail in error then please notify the sender immediately. The contents represent the views or opinions of the author only and are not necessarily made on behalf of the School. The recipient should check this e-mail and any attachments for the presence of viruses; the School does not accept liability for any damage caused by a transmitted virus.
################################################################################

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20151022/50d23c64/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Normalisation Notes Exercises.pdf
Type: application/pdf
Size: 783379 bytes
Desc: Normalisation Notes Exercises.pdf
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20151022/50d23c64/NormalisationNotesExercises-0001.pdf 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: normalizationexerciseanswer.pdf
Type: application/pdf
Size: 80149 bytes
Desc: normalizationexerciseanswer.pdf
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20151022/50d23c64/normalizationexerciseanswer-0001.pdf