<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.10240.16542"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; MARGIN: 0cm 0cm 0pt
}
LI.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; MARGIN: 0cm 0cm 0pt
}
DIV.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; MARGIN: 0cm 0cm 0pt
}
A:link {
TEXT-DECORATION: underline; COLOR: blue; mso-style-priority: 99
}
SPAN.MsoHyperlink {
TEXT-DECORATION: underline; COLOR: blue; mso-style-priority: 99
}
A:visited {
TEXT-DECORATION: underline; COLOR: purple; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
TEXT-DECORATION: underline; COLOR: purple; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Calibri",sans-serif; COLOR: #1f497d; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU vLink=purple link=blue bgColor=white>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial>A quick google found</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial><A
href="http://www.sanfoundry.com/database-mcqs-normal-forms/">http://www.sanfoundry.com/database-mcqs-normal-forms/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial><A
href="http://www.relationaldbdesign.com/relational-database-analysis/module3/normalization-quiz.php">http://www.relationaldbdesign.com/relational-database-analysis/module3/normalization-quiz.php</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial><A
href="http://www.siteforinfotech.com/2014/08/solved-mcq-on-database-normalization.html">http://www.siteforinfotech.com/2014/08/solved-mcq-on-database-normalization.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=755023711-22102015>
<DIV align=left>
<DIV dir=ltr align=left><SPAN class=141473702-12072015><FONT color=#0000ff
size=2 face=Arial>Robert Hind</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141473702-12072015><FONT color=#0000ff
size=2 face=Arial>Ex Traralgon and Ashwood</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=141473702-12072015><FONT color=#0000ff
size=2 face=Arial>Retired</FONT></SPAN></DIV></DIV></SPAN></DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Chris
Morgan<BR><B>Sent:</B> Thursday, 22 October 2015 9:59 PM<BR><B>To:</B> Year 12
IT Applications Teachers' Mailing List<BR><B>Subject:</B> Re: [Year 12 IT Apps]
Normalisation practical exercises for exam revision<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; COLOR: #1f497d; mso-fareast-language: EN-US'>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?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; COLOR: #1f497d; mso-fareast-language: EN-US'><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; COLOR: #1f497d; mso-fareast-language: EN-US'>Thanks
Chris<o:p></o:p></SPAN></P>
<P class=MsoNormal><A name=_MailEndCompose><SPAN
style='FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; COLOR: #1f497d; mso-fareast-language: EN-US'><o:p> </o:p></SPAN></A></P>
<DIV>
<DIV
style="BORDER-TOP: #e1e1e1 1pt solid; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 3pt; PADDING-LEFT: 0cm; BORDER-LEFT: medium none; PADDING-RIGHT: 0cm">
<P class=MsoNormal><B><SPAN lang=EN-US
style='FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif'>From:</SPAN></B><SPAN
lang=EN-US style='FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif'>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <B>On
Behalf Of </B>Robert Timmer-Arends<BR><B>Sent:</B> Thursday, 23 April 2015 6:12
PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing List
<itapps@edulists.com.au><BR><B>Subject:</B> Re: [Year 12 IT Apps]
Normalisation<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Hello Mark and
others</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>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.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>For example, when one
says 'a clear and logical way to explain normalisation' does one
mean:</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>- explain what
normalisation is</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>- explain why
normalisation is needed</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>- explain how to
recognise when a set of tables is (is not)
normalised</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>- explain what the
normal forms are</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>- explain how to arrive
at each normal form</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>- explain why each
normal form is defined the way it is (what it is trying to
prevent/achieve)</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>etc</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Regards</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Robert
T-A</SPAN><o:p></o:p></P></DIV>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: 4pt; BORDER-LEFT: black 1.5pt solid; MARGIN: 5pt 0cm 5pt 3.75pt; PADDING-RIGHT: 0cm">
<DIV>
<P class=MsoNormal><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>----- Original
Message ----- <o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal style="BACKGROUND: #e4e4e4"><B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>From:</SPAN></B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'> <A
title=mark@vceit.com href="mailto:mark@vceit.com">Mark</A>
<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>To:</SPAN></B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'> <A
title=itapps@edulists.com.au href="mailto:itapps@edulists.com.au">Year 12 IT
Applications Teachers' Mailing List</A> <o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Sent:</SPAN></B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'> Thursday, April 23,
2015 1:36 PM<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'>Subject:</SPAN></B><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Arial",sans-serif'> Re: [Year 12 IT
Apps] Normalisation<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>... slides which I'm <I>still</I> trying to get right.
:-o <o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>I keep trying to find a clear and logical way to explain
normalisation, but never quite get there.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal>Just be thankful we only need to get to 3NF, and not
5NF.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>Arghh!<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal>On 23 April 2015 at 13:24, Laurie Savage <<A
href="mailto:08327998@pvgc.vic.edu.au"
target=_blank>08327998@pvgc.vic.edu.au</A>> wrote:<o:p></o:p></P>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: 6pt; MARGIN-LEFT: 4.8pt; BORDER-LEFT: #cccccc 1pt solid; PADDING-RIGHT: 0cm; MARGIN-RIGHT: 0cm">
<DIV>
<DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt">I guess you have shown them
Mark Kelly's wonderful slides?<o:p></o:p></P></DIV>
<P class=MsoNormal>Laurie<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><BR clear=all><o:p></o:p></P>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<P class=MsoNormal>Laurie
Savage<o:p></o:p></P></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal>On 23 April 2015 at 11:34, Sylvia Pastore <<A
href="mailto:smp191172@gmail.com" target=_blank>smp191172@gmail.com</A>>
wrote:<o:p></o:p></P>
<BLOCKQUOTE
style="BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: 6pt; MARGIN-LEFT: 4.8pt; BORDER-LEFT: #cccccc 1pt solid; PADDING-RIGHT: 0cm; MARGIN-RIGHT: 0cm">
<DIV>
<DIV>
<P class=MsoNormal>Hi all,<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal>Would anyone have any tasks relating to normalisation
that they are willing to share, my kids need more
practise.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>Thanks<o:p></o:p></P></DIV></DIV>
<P
class=MsoNormal><BR>_______________________________________________<BR><A
href="http://www.edulists.com.au"
target=_blank>http://www.edulists.com.au</A> - FAQ, resources, subscribe,
unsubscribe<BR>IT Applications Mailing List kindly supported by<BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"
target=_blank>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority <br><BR><A
href="http://www.vitta.org.au"
target=_blank>http://www.vitta.org.au</A> - VITTA Victorian
Information Technology Teachers Association Inc <br><BR><A
href="http://www.swinburne.edu.au/ict/schools"
target=_blank>http://www.swinburne.edu.au/ict/schools</A> - Swinburne
University<o:p></o:p></P></BLOCKQUOTE></DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<P class=MsoNormal><BR>_______________________________________________<BR><A
href="http://www.edulists.com.au"
target=_blank>http://www.edulists.com.au</A> - FAQ, resources, subscribe,
unsubscribe<BR>IT Applications Mailing List kindly supported by<BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html"
target=_blank>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority <br><BR><A
href="http://www.vitta.org.au"
target=_blank>http://www.vitta.org.au</A> - VITTA Victorian
Information Technology Teachers Association Inc <br><BR><A
href="http://www.swinburne.edu.au/ict/schools"
target=_blank>http://www.swinburne.edu.au/ict/schools</A> - Swinburne
University<o:p></o:p></P></BLOCKQUOTE></DIV>
<P class=MsoNormal><BR><BR clear=all><o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<P class=MsoNormal>-- <o:p></o:p></P>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 9pt">>> Witty sig goes HERE
<<</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>Mark Kelly<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal>mark AT vceit DOT com<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><A href="http://vceit.com"
target=_blank>http://vceit.com</A><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV></DIV>
<DIV>
<P
class=MsoNormal><o:p> </o:p></P></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center SIZE=3 width="100%">
</DIV>
<P class=MsoNormal>_______________________________________________<BR><A
href="http://www.edulists.com.au">http://www.edulists.com.au</A> - FAQ,
resources, subscribe, unsubscribe<BR>IT Applications Mailing List kindly
supported by<BR><A
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</A>
- Victorian Curriculum and Assessment Authority <br><BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au</A> - VITTA
Victorian Information Technology Teachers Association Inc <br><BR><A
href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</A>
- Swinburne
University<o:p></o:p></P></BLOCKQUOTE></DIV><BR><BR>################################################################################
<BR>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.
<BR>################################################################################
<HR SIZE=1 noShade>
<A></A>
<P align=left color="#000000" avgcert??>No virus found in this
message.<BR>Checked by AVG - <A
href="http://www.avg.com">www.avg.com</A><BR>Version: 2015.0.6172 / Virus
Database: 4450/10859 - Release Date: 10/20/15</P></BODY></HTML>