<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;}
/* 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-reply;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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 link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt'><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'>Peter <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'>I would have separated the DB into three tables as part of 2NF and then got rid of the Total fee calculation field as 3NF<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'>And students should at least show the completed Relationship Diagram.<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'>Tricky part is explaining how each (do they mean separately?) normal form ensures the integrity of data.<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'>But I will wait and see what the gurus have to say (you out there Mark K?)<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"'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <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'><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@01CDC253.07EA4480" alt="Luther College" name="13afbe52e1922852_luther"></span></a><o:p></o:p></p></td></tr></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.<br><br><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></div></body></html>