<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=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@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:0in;
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:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
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:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks, Mark. Provided you’re correct, then you’ve only confirmed my fears. Some of my students probably had trouble resisting the logical inclination to create a separate table to address the 2<sup>nd</sup> repeating field. <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 agree with everything you’ve written below, which means I wasn’t confused by question per se. Instead, I was more confused by the fact the examiners expected students to craft such an unrealistic response to demonstrate their understanding of 1NF. Surely there are better, more realistic ways to demonstrate this.<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><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span 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<br><b>Sent:</b> Monday, November 10, 2014 4:44 PM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT Apps] IT Apps Exam, Short Answer, Question 7A<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span 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>Vear, Gary D</span><span lang=EN-AU><o:p></o:p></span></p></div></div></div></div></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>Will students be penalised if they do the sensible thing and normalise this data to 2NF by creating separate tables?</span><span lang=EN-AU><o:p></o:p></span></p></div></div><div><p><span lang=EN-AU style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black'>I'd appreciate feedback/corrections from others on this question, since it has me somewhat confused.</span><span lang=EN-AU><o:p></o:p></span></p></div></div></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I fear that a student who (logically and properly) translated the table to 2NF <b>would</b> be penalised since the question asked for knowledge of <b>1NF</b>.<o:p></o:p></p></div><div><p class=MsoNormal>Any 1NF solution (with a single, ugly table) would be technically correct (no repeating fields, one datum per field) but completely useless as a table.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>That's what chews my Chihuahuas. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Normalising to 1NF is a completely artificial exercise. Normalisation is a destination, and the 1,2,3 steps are purely <b>logical</b> - not practical - stages, simply to aid theoretical elucidation. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>In practice, you <b>never</b> start with 1NF, proceed to 2 and fix things up with 3.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>For a start, 2NF problems are never even going to happen if you start every new table with a key field. <o:p></o:p></p></div><div><p class=MsoNormal>Bang. <o:p></o:p></p></div><div><p class=MsoNormal>Problem solved. <o:p></o:p></p></div><div><p class=MsoNormal>No multiple-field keys, so no 2NF issues. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>If you <b>start</b> a database design with an understanding of 2NF you never need to experience 2NF problems. <o:p></o:p></p></div><div><p class=MsoNormal>I know <b>theoretically</b> that falling into an open sewer is not good. I don't need to be <b>pushed </b>into the cesspit to see if I know how to get out.<o:p></o:p></p></div><div><p class=MsoNormal>I side-step it before I get to it.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Similarly, you don't start a database by throwing fields together carelessly and then sorting problems out later, step by step.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Slave: Here, mighty Pharaoh. We have finished your million-ton tomb.<o:p></o:p></p></div><div><p class=MsoNormal>Pharaoh: O goody. Does it have a burial chamber in it?<o:p></o:p></p></div><div><p class=MsoNormal>Slave: O dear. Give us twenty years. We'll fix it. Then you can ask if the pointy end is at the top or not.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I know that the examiners want to test whether students understand the logic behind attaining 1NF. <o:p></o:p></p></div><div><p class=MsoNormal>That's great. I love them for it.<o:p></o:p></p></div><div><p class=MsoNormal>Capable students could easily and quickly have shown their understanding of 1NF in this exam if they'd been given a a table with <b>one</b> repeating field.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>But to add the <b>second</b> repeating field? That was just ugly and unnecessary.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Student: "Of course I know 1NF. I split the repeating values into new records... but what the hell do I do with the second repeating field? I can't meaningfully fix that with a single table. I'd need to get to 2NF to do that. I can't do anything sensible with a single table. What am I supposed to do? OK. I'll go to 2NF and lose all my marks..."<o:p></o:p></p></div><div><p class=MsoNormal><br>The question mistakenly assumed that having 2 repeating fields would be twice as hard as having 1 repeating field. <o:p></o:p></p></div><div><p class=MsoNormal><br>Wrong. The level of difficulty was exponential, not additive <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I feel better now.<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><div><div><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><p class=MsoNormal><i>I love the sound of people's voices after they stop talking.</i><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal>I, Mark Kelly, am entirely responsible for the offensive verbiage I spew forth.<o:p></o:p></p></div><div><p class=MsoNormal>Have I offended anyone with this post? I would not be surprised.<o:p></o:p></p></div><div><p class=MsoNormal>If offended, please whinge to me at the email address above. <o:p></o:p></p></div><div><p class=MsoNormal>Please leave poor Kevork alone. It is not his fault.<o:p></o:p></p></div></div></div></div></div></div></div></div></div>
<br /><br />
<hr style='border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;' />
<table style='border-collapse:collapse;border:none;'>
<tr>
<td style='border:none;padding:0px 15px 0px 8px'>
<a href="http://www.avast.com/">
<img border=0 src="http://static.avast.com/emails/avast-mail-stamp.png" />
</a>
</td>
<td>
<p style='color:#3d4d5a; font-family:"Calibri","Verdana","Arial","Helvetica"; font-size:12pt;'>
This email is free from viruses and malware because <a href="http://www.avast.com/">avast! Antivirus</a> protection is active.
</p>
</td>
</tr>
</table>
<br />
<p></p><p><b>Important - </b>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 Early Childhood Development.</p>
</body></html>