<html 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" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[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 Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-AU;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:273246872;
mso-list-template-ids:966717448;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:45.0pt;
mso-level-number-position:left;
margin-left:45.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:81.0pt;
mso-level-number-position:left;
margin-left:81.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:117.0pt;
mso-level-number-position:left;
margin-left:117.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:153.0pt;
mso-level-number-position:left;
margin-left:153.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:189.0pt;
mso-level-number-position:left;
margin-left:189.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:225.0pt;
mso-level-number-position:left;
margin-left:225.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:261.0pt;
mso-level-number-position:left;
margin-left:261.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:297.0pt;
mso-level-number-position:left;
margin-left:297.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:333.0pt;
mso-level-number-position:left;
margin-left:333.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:396049582;
mso-list-template-ids:825550740;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:45.0pt;
mso-level-number-position:left;
margin-left:45.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:81.0pt;
mso-level-number-position:left;
margin-left:81.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:117.0pt;
mso-level-number-position:left;
margin-left:117.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:153.0pt;
mso-level-number-position:left;
margin-left:153.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:189.0pt;
mso-level-number-position:left;
margin-left:189.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:225.0pt;
mso-level-number-position:left;
margin-left:225.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:261.0pt;
mso-level-number-position:left;
margin-left:261.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:297.0pt;
mso-level-number-position:left;
margin-left:297.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:333.0pt;
mso-level-number-position:left;
margin-left:333.0pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2
{mso-list-id:864488277;
mso-list-template-ids:-1066479834;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:49.5pt;
mso-level-number-position:left;
margin-left:49.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:85.5pt;
mso-level-number-position:left;
margin-left:85.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:121.5pt;
mso-level-number-position:left;
margin-left:121.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:157.5pt;
mso-level-number-position:left;
margin-left:157.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:193.5pt;
mso-level-number-position:left;
margin-left:193.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:229.5pt;
mso-level-number-position:left;
margin-left:229.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:265.5pt;
mso-level-number-position:left;
margin-left:265.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:301.5pt;
mso-level-number-position:left;
margin-left:301.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:337.5pt;
mso-level-number-position:left;
margin-left:337.5pt;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I worst part of the question 9 is that “explain how each normal form (1-3) ensures the integrity of data”<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I taught my kids what each of the normal forms 1 to 3 are, like you did. I even SACed it in U3O2 and made it a focus this year (thankfully)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">BUT<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">To explain how each of the normal forms ensures integrity individually…. I have a Bachelor of Applied Computing (having done database units) and I don’t know
how to explain that, the way I think VCAA is asking…..<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I did joke with my students coming out of the exam that obviously VCAA said an 8 mark question that 25% got 0 on wasn’t hard enough. Let’s give than 2 pages
and a 9 marker…. AND a 6 mark normalisation question (with explain each form…..)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Ta<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Ben Hines<o:p></o:p></span></p>
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></a></p>
<div>
<meta name="GENERATOR" content="MSHTML 8.00.7601.17573">
<font face="calibri"><font face="calibri"><font color="#800000" size="2">
<p><strong><font style="FONT-SIZE: 11pt" face="Arial"><font style="FONT-SIZE: 11pt"><font style="FONT-SIZE: 11pt"><font style="FONT-SIZE: 11pt">Ben Hines<br>
</font></font></font></font></strong><font style="FONT-SIZE: 11pt" face="Arial"><font style="FONT-SIZE: 11pt"><font style="FONT-SIZE: 11pt"><font style="FONT-SIZE: 11pt">Mathematics and ICT Teacher<br>
Senior Campus<br>
(03)5241 1577</font></font></font></font></p>
<p></font></font></font><font face="calibri"><font face="calibri"><font face="calibri"><font face="calibri"><font face="calibri"><font face="calibri"><font face="calibri"><img border="0" hspace="0" alt="Christian College Geelong" src="https://www.ccg.vic.edu.au/email/images/ccg.jpg"></font></font></font></font></font></font></font></p>
<p><font face="Calibri"><span style="FONT-FAMILY: Webdings; FONT-SIZE: 16pt; mso-fareast-font-family: 'MS Mincho'; mso-fareast-theme-font: minor-fareast; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-AU; mso-fareast-language: JA; mso-bidi-language: AR-SA"><strong><img style="WIDTH: 22px; HEIGHT: 33px" alt="" src="https://www.ccg.vic.edu.au/email/images/Enviro.jpg" width="34" height="28"> </strong></span><font size="2">Please
consider the environment before printing this email.</font></font></p>
<br>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au]
<b>On Behalf Of </b>Mark Scott<br>
<b>Sent:</b> Wednesday, 14 November 2012 10:46 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] NINE mark question??<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">This is the definition of the Normalisation process that I have been using<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:18.0pt;margin-left:36.0pt">
<b><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">First Normal Form (1NF)<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">First normal form (1NF) sets the very basic rules for an organized database:
<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l2 level1 lfo2">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Eliminate duplicative
<a href="http://databases.about.com/library/glossary/bldef-column.htm"><span style="color:#3366CC">columns</span></a> from the same table.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l2 level1 lfo2">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Create separate tables for each group of related data and identify each
<a href="http://databases.about.com/library/glossary/bldef-row.htm"><span style="color:#3366CC">row</span></a> with a unique column or set of columns (the
<a href="http://databases.about.com/library/glossary/bldef-primarykey.htm"><span style="color:#3366CC">primary key</span></a>).<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:18.0pt;margin-left:36.0pt">
<b><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Second Normal Form (2NF)<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Second normal form (2NF) further addresses the concept of removing duplicative data:
<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l0 level1 lfo4">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Meet all the requirements of the first normal form.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l0 level1 lfo4">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Remove subsets of data that apply to multiple rows of a table and place them in separate tables.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l0 level1 lfo4">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Create relationships between these new tables and their predecessors through the use of
<a href="http://databases.about.com/library/glossary/bldef-foreignkey.htm"><span style="color:#3366CC">foreign keys</span></a>.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:18.0pt;margin-left:36.0pt">
<b><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Third Normal Form (3NF)<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Third normal form (3NF) goes one large step further:
<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l1 level1 lfo6">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Meet all the requirements of the second normal form.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:49.5pt;text-indent:-18.0pt;mso-list:l1 level1 lfo6">
<![if !supportLists]><span lang="EN" style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span lang="EN" style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#333333">Remove columns that are not
<a href="http://databases.about.com/od/specificproducts/a/Database-Dependency.htm">
<span style="color:#3366CC">dependent</span></a> upon the primary key.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">In terms of Q6<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">1NF as per Peter’s example<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">2NF Split into three tables<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">3NF Get rid of the calculated field<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">It is a bit annoying that VCAA couldn’t prepare us for this sort of question and indeed wouldn’t even give us a definition of the process.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Mark Scott<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Luther College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</a>]
<b>On Behalf Of </b>Peter Langham<br>
<b>Sent:</b> Wednesday, 14 November 2012 10:05 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] NINE mark question??<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Here's my attempt at the normalisation question<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">1NF - No lists of data in any cell.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Divide the data in any of the memberName, memberAddress, driverName fields.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">memberAddress becomes: memberAddress becomes memberAddress and memberPostcode<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">E.g. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">memberAddress : 2 Hill St<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">memberSuburb : Richmond<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">This allows for more specific queries. E.g. Filtering data by Suburb.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">2NF - each non-key field must be fully dependent on the key<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">yearsWorked is dependent on driverName. Make a seperate table where driverName is the Primary Key and it is a Foreign Key in the memberName table.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Table 1: memberName, memberAddress, driverName (foreign key), carRate($), totalFee($)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Table 2: driverName (primary key), yearsWorked<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">This ensures data integrity as the yearsWorked data would only need to be updated in the one cell now instead of multiple cells.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">3NF - every field in a table must relate directly to the primary key<br>
carRate($) is dependent on the size of the car. I'd add a foreign key field to table1 carSize which would become a primary key field in the third table.<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Table 1: memberName, memberAddress, driverName (foreign key), carSize (foreign key)
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Table 2: driverName (primary key), yearsWorked<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Table 3: carSize, carRate($)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">This leaves us with what I beleive should be a calculated field, totalFee($).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">totalFee($): [yearsWorked]*[carRate($)]<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">I may have 2NF and 3NF in the wrong order.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Unfortunately, I didn't go over this in a lot of depth with my students, I expected that they would have the choice of which Normal Form they solved for, like the VCAA sample exam so we focused on 1NF more heavily
than the other two normal forms.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Peter Langham<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">Narre Warren South P-12<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:36.0pt">On Wed, Nov 14, 2012 at 9:30 AM, Mark Scott <<a href="mailto:msc@luther.vic.edu.au" target="_blank">msc@luther.vic.edu.au</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt">Mark</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt">It will be Q9 (the Normalisation one) that will be the one most poorly answered.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt">I am looking forward to seeing your solution for that one.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt;font-family:Wingdings">J</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt">Mark Scott<br>
Luther College</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:36.0pt">
<span style="font-size:11.0pt"> </span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="400" style="width:300.0pt;margin-left:36.0pt">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#184689">Mark Scott
</span></b><b><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#184689"><br>
</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#184689">Daily Administrator<br>
</span><span style="font-size:5.5pt;font-family:"Arial","sans-serif";color:white">Luther</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#808285">Plymouth Road<br>
Croydon Hills Victoria 3136<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:5.5pt;font-family:"Arial","sans-serif";color:white">Luther</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#808285">Telephone (03) 9724 2000<br>
Direct Line (03) 9724 2023 <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#808285"><a href="http://www.luther.vic.edu.au/" target="_blank"><span style="color:#808285;text-decoration:none">www.luther.vic.edu.au</span></a>
<o:p></o:p></span></p>
</div>
</div>
</td>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><a href="http://www.luther.vic.edu.au/" target="_blank"><span style="font-family:"Arial","sans-serif";text-decoration:none"><img border="0" width="143" height="143" id="_x0000_i1025" src="cid:image001.png@01CDC270.C15E7090" alt="Luther College" name="13afbe52e1922852_luther"></span></a><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div style="margin-top:7.5pt;float:left">
<p class="MsoNormal" style="margin-left:36.0pt"><b><span style="font-size:7.0pt;font-family:"Arial","sans-serif";color:#CA003A">Please consider the environment before printing this email.</span></b><o:p></o:p></p>
<p style="mso-margin-top-alt:3.75pt;margin-right:0cm;margin-bottom:5.0pt;margin-left:36.0pt;line-height:110%">
<span style="font-size:7.0pt;line-height:110%;font-family:"Arial","sans-serif";color:#808285">This email and any attachments may contain privileged and confidential information.
<br>
If you are not the intended recipient you may not distribute or reproduce this email
<br>
or attachments. If you have received this message in error please notify us by return mail.<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><br clear="all">
<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:36.0pt"><o:p> </o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a>]
<b>On Behalf Of </b>Mark KELLY<br>
<b>Sent:</b> Wednesday, 14 November 2012 9:15 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 IT Apps] NINE mark question??</span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
I wonder what the logic was behind changing the eight mark question into a nine mark question.<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
Was it something like, "Let's take the question that was most poorly answered last year and make it even more difficult." ?<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:72.0pt">
<o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:72.0pt">
-- <br>
Mark Kelly - <a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
Manager of ICT, Reporting, IT Learning Area<br>
McKinnon Secondary College, McKinnon Rd, McKinnon 3204, Victoria, Australia<br>
Phone: <a href="tel:%2B613%208520%209085" target="_blank">+613 8520 9085</a>, Fax
<a href="tel:%2B613%209578%209253" target="_blank">+613 9578 9253</a><br>
VCE IT Lecture Notes: <a href="http://vceit.com/" target="_blank">http://vceit.com</a><br>
Moderator: <a href="http://edulists.com.au/itapps/index.htm" target="_blank">IT Applications Edulist</a><br>
Visit Diigo links for <a href="http://groups.diigo.com/group/vce-info-tech" target="_blank">
ITA</a> and <a href="http://groups.diigo.com/group/vce-sd" target="_blank">SD</a><br>
--<br>
My personal best for the 100 metre sprint is 11.9 metres.<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><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>
</div>
<p class="MsoNormal" style="margin-left:36.0pt"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" align="center">
</div>
<p class="MsoNormal">Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br>
<a href="http://www.mailguard.com.au">http://www.mailguard.com.au</a><br>
<br>
<a href="https://login.mailguard.com.au/report/1FX4DOYU4R/30j9XQftBeKlNajRBhAsLc/0.013">Report this message as spam</a> <br>
<o:p></o:p></p>
</div>
</body>
</html>
<br>This e-mail is intended for the use of the named individual or entity and may contain confidential and privileged information. Any dissemination, distribution or copying by anyone other than the intended recipient of this e-mail is strictly prohibited. If this e-mail has been received in error, then please notify Christian College or the author of this email immediately and destroy the original message. We have made every attempt to ensure this e-mail message is free from computer viruses however the attached files are provided on the basis that the user assumes all responsibility for use of the material transmitted. Views, opinions, etc. expressed reflect those of the author and not Christian College nor its associated companies and campuses which includes Eden Quality Services Pty Ltd.<br>
<br><hr size=1>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<br><a href=http://www.mailguard.com.au>http://www.mailguard.com.au</a><br>
<!-- MailGuard Message ID: 50a309e91c1480 - use this number for reporting -->
<br> <br>