<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>@font-face {
font-family: Helvetica;
}
@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@page WordSection1 {margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
LI.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
DIV.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
A:link {
TEXT-DECORATION: underline; COLOR: #0563c1
}
SPAN.MsoHyperlink {
TEXT-DECORATION: underline; COLOR: #0563c1
}
A:visited {
TEXT-DECORATION: underline; COLOR: #954f72
}
SPAN.MsoHyperlinkFollowed {
TEXT-DECORATION: underline; COLOR: #954f72
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d
}
.MsoChpDefault {
FONT-SIZE: 10pt
}
</style><style id="owaParaStyle">P {
MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
</style>
</head>
<body lang="EN-AU" link="#0563c1" vlink="#954f72" fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>Hi all,</p>
<p> </p>
<p>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:</p>
<p> </p>
<p>Choosing the first record (fancy_cat), here's what I think would be required for full marks:</p>
<p> </p>
<p>
<table style="WIDTH: 271pt; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="361" border="0">
<colgroup><col style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width="71"><col style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width="89"><col style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3510" width="96"><col style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width="105"></colgroup>
<tbody>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl63" style="BORDER-TOP: windowtext 0.5pt solid; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; WIDTH: 53pt; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20" width="71">
<strong><font face="Calibri">userName</font></strong></td>
<td class="xl63" style="BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; WIDTH: 67pt; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent" width="89">
<strong><font face="Calibri">fullName</font></strong></td>
<td class="xl63" style="BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; WIDTH: 72pt; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent" width="96">
<strong><font face="Calibri">interestGroup</font></strong></td>
<td class="xl63" style="BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; WIDTH: 79pt; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent" width="105">
<strong><font face="Calibri">contactList</font></strong></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">love_planes</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">paperclip55</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">love_planes</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">panic_disco</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">love_planes</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">starwarsfan</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">love_planes</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">melanie_franks</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">love_planes</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">WalterEllison27</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">classOf2104</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">paperclip56</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">classOf2105</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">panic_disco</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">classOf2106</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">starwarsfan</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">classOf2107</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">melanie_franks</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">classOf2108</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">WalterEllison28</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">cooking_rox</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">paperclip57</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">cooking_rox</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">panic_disco</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">cooking_rox</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">starwarsfan</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">cooking_rox</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">melanie_franks</font></td>
</tr>
<tr style="HEIGHT: 15pt" height="20">
<td class="xl64" style="BORDER-TOP: windowtext; HEIGHT: 15pt; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" height="20">
<font face="Calibri">fancy_cat</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">Francine Ulas</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">cooking_rox</font></td>
<td class="xl64" style="BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent">
<font face="Calibri">WalterEllison29</font></td>
</tr>
</tbody>
</table>
</p>
<p> </p>
<p>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?
</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>I'd appreciate feedback/corrections from others on this question, since it has me somewhat confused.</p>
<p> </p>
<p>Cheers,</p>
<p>Gary</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>