<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Calibri;
}
@page Section1 {margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d
}
P.Pa15 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.Pa15 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.Pa15 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
P.Pa4 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.Pa4 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.Pa4 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
P.Pa17 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.Pa17 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.Pa17 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
P.Pa18 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.Pa18 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.Pa18 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
P.Default {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; FONT-SIZE: 12pt
}
LI.Default {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; FONT-SIZE: 12pt
}
DIV.Default {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; FONT-SIZE: 12pt
}
P.Pa9 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.Pa9 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.Pa9 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
P.Pa13 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.Pa13 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.Pa13 {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
SPAN.A7 {
COLOR: #221e1f
}
.MsoChpDefault {
}
DIV.Section1 {
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</style>
<meta name="GENERATOR" content="MSHTML 8.00.7600.16722">
<style id="owaTempEditStyle"></style><style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
</head>
<body lang="EN-US" link="blue" bgcolor="#ffffff" vlink="purple" ocsi="x">
<div style="FONT-FAMILY: Tahoma; DIRECTION: ltr; COLOR: #000000; FONT-SIZE: 13px">
<div> </div>
<div><font size="2" face="tahoma">Well I'm sure that clears it up for everybody?</font></div>
<div><font size="2" face="tahoma"></font> </div>
<div><font size="2" face="tahoma">:-)</font></div>
<div><font size="2" face="tahoma"></font> </div>
<div><font size="2" face="tahoma">Mark Scott</font></div>
<div><font size="2" face="tahoma">Luther College</font></div>
<div><font size="2" face="tahoma"></font> </div>
<div><font size="2" face="tahoma">PS Paula, we need help with this one. </font></div>
<div dir="ltr"><font color="#000000" size="2" face="Tahoma"></font> </div>
<div style="DIRECTION: ltr" id="divRpF888955">
<hr tabindex="-1">
<font color="#000000" size="2" face="Tahoma"><b>From:</b> itapps-bounces@edulists.com.au [itapps-bounces@edulists.com.au] On Behalf Of Timmer-Arends [timmer@melbpc.org.au]<br>
<b>Sent:</b> Thursday, March 31, 2011 10:21 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] Table Normalisation<br>
</font><br>
</div>
<div></div>
<div>
<div><font size="2" face="Arial">Hello Laura</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">I think there is not enough info to give definitive answers:</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">ticking 'First', one could say that nothing would happen. Reason: from the 3 records given there are no repeating groups - for example two boats for one name - so the table already is in 1NF.</font></div>
<div><font size="2" face="Arial">However, one could argue that there appears to be no unique identifier for each record - there could be two Jon Rosses - so a primary key field needs to be added.</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">ticking 'Second', one could again say 'nothing'. Reason: We don't know what the primary key is, so, if we assume that 1NF adds a primary key field then the table is in 2NF already, so we don't do anything. Basically 2NF doesn't
allow a non-primary key column to be dependent on only part of the primary key. And from the info given there is no way to tell whether this is happening or not. So, if we supposed that Name and memType formed the primary key (why I don't know but let's go
with it), then 2NF would cause the three fees columns to disappear because they are presumably dependent only on memType; that is, they are not dependent on the complete primary key.</font></div>
<div><font size="2" face="Arial"></font><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">ticking 'Third', this time we can be more certain: the three fees columns would disappear (moved to create another table with memType as their primary key). Reason: the fees are dependent on memType (at least judging by the
info given; eg there does not seem to be any dependence on Gender) and memType is presumably not a primary key in the given table. Therefore the fees belong in their own table (the problem is that if, for example, the club changed its fee structure then, with
the table given, Sue might have her storage fee changed to the new amount, but Harry's might be overlooked - the db has lost integrity. 3NF prevents this.)</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">The distinction between 2NF and 3NF is this: 2NF requires non-key columns to be dependent on the
<strong>whole</strong> key, while 3NF requires non-key columns to de dependent only on the key and nothing else</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">Regards</font></div>
<div><font size="2" face="Arial">Robert T-A</font></div>
<div><font size="2" face="Arial">Brighton SC</font></div>
<div><font size="2" face="Arial"></font><font size="2" face="Arial"></font> </div>
<div> </div>
<div>----- Original Message ----- </div>
<blockquote style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<div style="FONT: 10pt arial; BACKGROUND: #e4e4e4"><b>From:</b> <a title="fihl@crcsydenham.net" href="mailto:fihl@crcsydenham.net">
Laura Fihelly</a> </div>
<div style="FONT: 10pt arial"><b>To:</b> <a title="itapps@edulists.com.au" href="mailto:itapps@edulists.com.au">
Year 12 IT Applications Teachers' Mailing List</a> </div>
<div style="FONT: 10pt arial"><b>Sent:</b> Thursday, March 31, 2011 10:59 AM</div>
<div style="FONT: 10pt arial"><b>Subject:</b> [Year 12 IT Apps] Table Normalisation</div>
<div><br>
</div>
<div class="Section1">
<p style="MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm" class="Pa15"><span style="FONT-FAMILY: 'Calibri','sans-serif'">Hi everyone</span><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 10pt">,</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt"></span> </p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt">Can someone please help me with this Sample Exam question. I am trying to understand table normalization. I have a general understanding of what it means, but I’m not really
sure about the actual differences in this particular question between the second and third normal forms. As a class we have been going through the textbook definition, but I’m struggling to apply it to this particular sample question.
</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt"></span> </p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt">Also if anyone has some good resources on a simple (not so technical way) of how to explain this easier it would be greatly appreciated.</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt"></span> </p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt">Thanks</span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"></span></b></p>
<p style="MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm" class="Pa15"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt">Question 1</span></b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"></span></p>
<p style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt" class="Pa4"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt">Below is a table from a yacht club’s relational database.</span></p>
<table style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; BORDER-COLLAPSE: collapse; BORDER-TOP: medium none; BORDER-RIGHT: medium none" class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" width="652">
<tbody>
<tr style="HEIGHT: 18.55pt">
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="98">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa17" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Name</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa17" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Boat Name</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="125">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa17" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Address_Suburb</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="60">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">State</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">memType</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Fees $</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Gender</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Boat Storage Fees $</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 18.55pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><b><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 8pt">Total Fees Due $</span></b></span><b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 8pt"></span></b></p>
</td>
</tr>
<tr style="HEIGHT: 12.55pt">
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="98">
<p style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt" class="Pa4"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Sue Trowsdale</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Suzy</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="125">
<p style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt" class="Pa4"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">21 Mountain Rd Rosebud</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="60">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">VIC</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Senior</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">250.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">F</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">125.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">375.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
</tr>
<tr style="HEIGHT: 12.55pt">
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="98">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Jon Ross</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Wahoo</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="125">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">64 View Rd McCrae</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="60">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">VIC</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Junior</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">140.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">M</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">–</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">140.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
</tr>
<tr style="HEIGHT: 12.55pt">
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="98">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Harry Wilson</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Victor</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="125">
<p style="MARGIN-BOTTOM: 2pt" class="Pa17"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">35 Shady Ln Rosebud</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="60">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">VIC</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="71">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">Life</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">–</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">M</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">125.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
<td style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.55pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm" valign="top" width="57">
<p style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt" class="Pa18" align="center"><span class="A7"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 9pt">125.00</span></span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 9pt"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-AU"></span> </p>
<p style="TEXT-ALIGN: right; MARGIN-BOTTOM: 5pt" class="Pa13" align="right"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt">2 marks</span></p>
<p style="TEXT-ALIGN: justify; TEXT-INDENT: -18pt; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 21.3pt; MARGIN-RIGHT: 0cm" class="Pa9">
<b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"><span>a.<span style="FONT: 7pt 'Times New Roman'">
</span></span></span></b><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt">Describe what would happen when you apply
<b>one </b>of the First, Second or Third Normal Forms to data in the table. Refer to the table in your answer.
</span></p>
<p style="TEXT-ALIGN: justify; TEXT-INDENT: -22pt; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 22pt; MARGIN-RIGHT: 0cm" class="Pa9">
<span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"></span> </p>
<p style="TEXT-ALIGN: justify; TEXT-INDENT: -22pt; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 22pt; MARGIN-RIGHT: 0cm" class="Pa9">
<span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt">Tick the box to indicate which normal form you are describing.
</span></p>
<p style="TEXT-ALIGN: justify; LINE-HEIGHT: 11.05pt; TEXT-INDENT: -22pt; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 22pt; MARGIN-RIGHT: 0cm" class="Default">
<span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"> First
</span><span style="FONT-FAMILY: Wingdings; COLOR: #221e1f; FONT-SIZE: 10pt">o</span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"> or Second
</span><span style="FONT-FAMILY: Wingdings; COLOR: #221e1f; FONT-SIZE: 10pt">o</span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt"> or Third
</span><span style="FONT-FAMILY: Wingdings; COLOR: #221e1f; FONT-SIZE: 10pt">o</span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #221e1f; FONT-SIZE: 10pt">
</span></p>
<p style="LINE-HEIGHT: 115%" class="Default"><span style="LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________</span></p>
<p style="LINE-HEIGHT: 115%" class="Default"><span style="LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">____________________________________________________________________________________</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"></span> </p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">Laura Fihelly</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">Teacher of Business Management & Information Technologies</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">Catholic Regional College Sydenham</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">380 Sydenham Road
</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">Sydenham 3037</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">email:
<a href="mailto:fihl@crcsydenham.net">fihl@crcsydenham.net</a></span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">web:
</span><a href="http://www.crcsydenham.net/" target="_blank"><span style="FONT-FAMILY: 'Arial','sans-serif'">www.crcsydenham.net</span></a><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d">
</span></p>
<p class="MsoNormal"> </p>
</div>
<p></p>
<hr>
<p></p>
_______________________________________________<br>
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and<br>
http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc</blockquote>
</div>
</div>
</body>
</html>