<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)">
<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:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:#1F497D;}
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;}
--></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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">No I don’t think you’re wrong, it’s a lot of busy work for a few marks. I felt the same way about this question. The kids would have needed to evaluate the
possible combinations to produce an answer that would need less rows to save writing time.<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>
<div>
<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>Vear, Gary D<br>
<b>Sent:</b> Friday, 7 November 2014 3:59 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 IT Apps] IT Apps Exam, Short Answer, Question 7A<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Hi all,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Not sure I like this question at all. Normalising to 1NF sounds simple enough, particularly when students are required to use just one set of sample records, but this seems like
it requires a lot for 3 marks:<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Choosing the first record (fancy_cat), here's what I think would be required for full marks:<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="361" style="width:271.0pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="71" style="width:53.0pt;border:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><strong><span style="font-family:"Calibri","sans-serif"">userName</span></strong><o:p></o:p></p>
</td>
<td width="89" style="width:67.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><strong><span style="font-family:"Calibri","sans-serif"">fullName</span></strong><o:p></o:p></p>
</td>
<td width="96" style="width:72.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><strong><span style="font-family:"Calibri","sans-serif"">interestGroup</span></strong><o:p></o:p></p>
</td>
<td width="105" style="width:79.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><strong><span style="font-family:"Calibri","sans-serif"">contactList</span></strong><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">love_planes</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">paperclip55</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">love_planes</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">panic_disco</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">love_planes</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">starwarsfan</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">love_planes</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">melanie_franks</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">love_planes</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">WalterEllison27</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">classOf2104</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">paperclip56</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">classOf2105</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">panic_disco</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">classOf2106</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">starwarsfan</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">classOf2107</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">melanie_franks</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">classOf2108</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">WalterEllison28</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">cooking_rox</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">paperclip57</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">cooking_rox</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">panic_disco</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">cooking_rox</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">starwarsfan</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">cooking_rox</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">melanie_franks</span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td style="border:solid windowtext 1.0pt;border-top:none;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">fancy_cat</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">Francine Ulas</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">cooking_rox</span><o:p></o:p></p>
</td>
<td style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 0cm 0cm 0cm;height:15.0pt">
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">WalterEllison29</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">That's 15 individual records students would have to write out, unless I'm mistaken. Will students be penalised if they do the sensible thing and normalise this data to 2NF by creating
separate tables? <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">I thought I understood normalising to 1NF, but perhaps I'm wrong. The addition of that 4th field (contactList) has seemingly made this a big challenge (15 lines of writing) for
just 3 marks.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<p><span 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.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black"> <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Cheers,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Gary<o:p></o:p></span></p>
</div>
<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.<o:p></o:p></p>
</div>
<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>