I'd be surprised if any of us covered normalisation to the extent that the question required. <div>A full discussion of all 3 normal forms - worth 6 marks?<div><br></div><div>Tell 'em they're dreamin'</div>
<div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 14 November 2012 10:05, Peter Langham <span dir="ltr"><<a href="mailto:peterlangham1983@gmail.com" target="_blank">peterlangham1983@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Here's my attempt at the normalisation question</div>
<div> </div>
<div>1NF - No lists of data in any cell. </div>
<div>Divide the data in any of the memberName, memberAddress, driverName fields. </div>
<div>memberAddress becomes: memberAddress becomes memberAddress and memberPostcode</div>
<div>E.g. </div>
<div>memberAddress : 2 Hill St</div>
<div>memberSuburb : Richmond</div>
<div>This allows for more specific queries. E.g. Filtering data by Suburb.</div>
<div> </div>
<div>2NF - each non-key field must be fully dependent on the key</div>
<div>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.</div>
<div>Table 1: memberName, memberAddress, driverName (foreign key), carRate($), totalFee($)</div>
<div>Table 2: driverName (primary key), yearsWorked</div>
<div>This ensures data integrity as the yearsWorked data would only need to be updated in the one cell now instead of multiple cells.</div>
<div> </div>
<div>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.</div>
<div>
<div>Table 1: memberName, memberAddress, driverName (foreign key), carSize (foreign key) </div>
<div>Table 2: driverName (primary key), yearsWorked</div>
<div>Table 3: carSize, carRate($)</div>
<div> </div>
<div>This leaves us with what I beleive should be a calculated field, totalFee($).</div>
<div>totalFee($): [yearsWorked]*[carRate($)]</div>
<div> </div>
<div>I may have 2NF and 3NF in the wrong order.</div>
<div> </div>
<div>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.</div>
<div> </div></div>
<div>Peter Langham</div>
<div>Narre Warren South P-12</div>
<div> </div>
<div class="gmail_quote">On Wed, Nov 14, 2012 at 9:30 AM, Mark Scott <span dir="ltr"><<a href="mailto:msc@luther.vic.edu.au" target="_blank">msc@luther.vic.edu.au</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div lang="EN-AU" vlink="purple" link="blue">
<div>
<p class="MsoNormal"><span style="FONT-SIZE:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt">Mark<u></u><u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt">It will be Q9 (the Normalisation one) that will be the one most poorly answered.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt">I am looking forward to seeing your solution for that one.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="FONT-FAMILY:Wingdings;FONT-SIZE:11pt">J</span><span style="FONT-SIZE:11pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt">Mark Scott<br>Luther College<u></u><u></u></span></p>
<p class="MsoNormal"><span style="FONT-SIZE:11pt"><u></u> <u></u></span></p>
<p></p>
<table style="WIDTH:400px" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td><span style="FONT-FAMILY:arial;COLOR:#184689;FONT-SIZE:13px;FONT-WEIGHT:bold;PADDING-TOP:5px">Mark Scott </span><span style="FONT-FAMILY:arial;COLOR:#184689;FONT-SIZE:10px;FONT-WEIGHT:bold;PADDING-TOP:5px"><br></span><span style="MARGIN-TOP:0px;FONT-FAMILY:arial;COLOR:#184689;FONT-SIZE:12px">Daily Administrator<br>
</span><span style="MARGIN-TOP:0px;FONT-FAMILY:arial;COLOR:#ffffff;FONT-SIZE:7px">Luther<br></span>
<div style="FONT-FAMILY:arial;COLOR:#808285;FONT-SIZE:12px;PADDING-TOP:15px">Plymouth Road<br>Croydon Hills Victoria 3136<br></div><span style="MARGIN-TOP:0px;FONT-FAMILY:arial;COLOR:#ffffff;FONT-SIZE:7px">Luther<br></span>
<div style="FONT-FAMILY:arial;COLOR:#808285;FONT-SIZE:12px;PADDING-TOP:5px"><span>Telephone <a href="tel:%2803%29%209724%202000" value="+61397242000" target="_blank">(03) 9724 2000</a><br>Direct Line</span> <a href="tel:%2803%29%209724%202023" value="+61397242023" target="_blank">(03) 9724 2023</a>
<div style="COLOR:#808285;PADDING-TOP:5px"><a style="COLOR:#808285;TEXT-DECORATION:none" href="http://www.luther.vic.edu.au/" target="_blank"><font face="Arial">www.luther.vic.edu.au</font></a>
<div style="COLOR:#808285;FONT-SIZE:9px;PADDING-TOP:5px"></div></div></div></td>
<td><a href="http://www.luther.vic.edu.au/" target="_blank"><font face="Arial"><img style="MIN-HEIGHT:143px;WIDTH:143px" title="Luther College" border="0" name="13afc1398fbb40ca_13afbe52e1922852_luther" hspace="0" alt="Luther College" align="textTop" src="cid:luther_college_email4823.png" width="143" height="143"></font></a></td>
</tr></tbody></table>
<p></p>
<p></p>
<div style="MARGIN-TOP:10px;WIDTH:100%;FLOAT:left;CLEAR:both"><span style="LINE-HEIGHT:110%;FONT-FAMILY:arial;COLOR:#ca003a;FONT-SIZE:9px;FONT-WEIGHT:bold">Please consider the environment before printing this email.<br></span>
<p style="LINE-HEIGHT:110%;MARGIN-TOP:5px;FONT-FAMILY:arial;COLOR:#808285;FONT-SIZE:9px">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.</p></div><br style="CLEAR:both">
<div></div><br>
<p style="MARGIN-LEFT:36pt" class="MsoNormal"><b><span style="FONT-FAMILY:'Tahoma','sans-serif';FONT-SIZE:10pt" lang="EN-US">From:</span></b><span style="FONT-FAMILY:'Tahoma','sans-serif';FONT-SIZE:10pt" lang="EN-US"> <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??<u></u><u></u></span></p>
<div>
<div>
<p style="MARGIN-LEFT:36pt" class="MsoNormal"><u></u> <u></u></p>
<p style="MARGIN-LEFT:36pt" class="MsoNormal">I wonder what the logic was behind changing the eight mark question into a nine mark question.<u></u><u></u></p>
<div>
<p style="MARGIN-LEFT:36pt" class="MsoNormal"><u></u> <u></u></p>
<div>
<p style="MARGIN-LEFT:36pt" class="MsoNormal">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"><u></u><u></u></p>
<div>
<p style="MARGIN-LEFT:36pt" class="MsoNormal"><u></u> <span class="HOEnZb"><font color="#888888"><u></u></font></span></p></div><span class="HOEnZb"><font color="#888888">
<p style="MARGIN-BOTTOM:12pt;MARGIN-LEFT:36pt;MARGIN-RIGHT:0cm" class="MsoNormal">-- <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" value="+61385209085" target="_blank">+613 8520 9085</a>, Fax <a href="tel:%2B613%209578%209253" value="+61395789253" 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><br><u></u><u></u></p></font></span></div></div></div></div></div></div><span class="HOEnZb"><font color="#888888"><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<br>
</font></span></blockquote></div><br>
<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<br></blockquote></div><br><br clear="all"><div><br></div>-- <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: +613 8520 9085, Fax +613 9578 9253<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><br><br>
</div>