<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Hi Mark,</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Nothing so interesting as discussing NF1-3, more a
Panadeine Forte and a bottle of red I would have thought :-) The
article I suggested was the "least confusing" of several found. There does
however seem to be perhaps a need for the VCAA to spell out a bit more clearly
its meanings of NF1-3 as there do seem to be several different versions
around.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>If you want a really clear explanation :-( then try
<A
href="http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html#03">http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html#03</A></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I would be interested to know the origin
of Laura's sample question. And just what they did expect as an answer for
two marks. Also how can you apply just one of NF1, NF2 or NF3 to a table when
each one assumes the previous requirements have been satisfied?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Where do we go?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>1NF: Two new fields in the database table so that
the "Street Address" and "Suburb" become separate fields and "Family_Name" and
"Given_Name" also become separate fields - atomicity, no more than one
value in a field</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>2NF: Dividing the data into at least two
tables: eg perhaps Member_Details: Primary key, Member names, Address details,
Gender (? is gender needed, if not is it allowed under present laws?),
Membership type</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial> </FONT><FONT size=2 face=Arial>and
Membership_Types: Primary key, Membership fee, Boat storage fee</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>and establishing the relationships between the
tables</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>3NF: ? Perhaps nothing more.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Robert Hind (Semi-retired) OOF, GOM<BR>Ashwood and
Traralgon<BR><A
href="mailto:robert@yinnar.com">robert@yinnar.com</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </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">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=kel@mckinnonsc.vic.edu.au
href="mailto:kel@mckinnonsc.vic.edu.au">Mark KELLY</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 2:28
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Table
Normalisation</DIV>
<DIV><BR></DIV>I looked up normalisation levels 1-3 and had to have a Bex and
a good lie down.<BR><BR>It's funny because normally I love discussing things
like how NF2 aims to ensure that no non-prime attribute in the table is
functionally dependent on a proper subset of a candidate
key.<BR><BR>:-o<BR><BR>
<DIV class=gmail_quote>On 31 March 2011 13:02, Robert Hind <SPAN
dir=ltr><<A
href="mailto:robert@yinnar.com">robert@yinnar.com</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-US vlink="purple" bgcolor="#ffffff" link="blue">
<DIV><FONT size=2 face=Arial>You might like to look at</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial><A
href="http://databases.about.com/od/specificproducts/a/normalization.htm"
target=_blank>http://databases.about.com/od/specificproducts/a/normalization.htm</A></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Robert Hind (Semi-retired) OOF, GOM<BR>Ashwood
and Traralgon<BR><A href="mailto:robert@yinnar.com"
target=_blank>robert@yinnar.com</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="FONT: 10pt arial; BACKGROUND: #e4e4e4"><B>From:</B> <A
title=fihl@crcsydenham.net href="mailto:fihl@crcsydenham.net"
target=_blank>Laura Fihelly</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au" target=_blank>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>
<P
style="MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm"><SPAN>Hi
everyone</SPAN><SPAN style="FONT-SIZE: 10pt">,</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt"></SPAN> </P>
<P class=MsoNormal><SPAN style="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-SIZE: 11pt"></SPAN> </P>
<P class=MsoNormal><SPAN style="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-SIZE: 11pt"></SPAN> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 11pt">Thanks</SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt"></SPAN></B></P>
<P
style="MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm"><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt">Question 1</SPAN></B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt"></SPAN></P>
<P style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt"><SPAN
style="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"
border=1 cellSpacing=0 cellPadding=0 width=652>
<TBODY>
<TR style="MIN-HEIGHT: 18.55pt">
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN
style="FONT-SIZE: 8pt">Name</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN style="FONT-SIZE: 8pt">Boat
Name</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN
style="FONT-SIZE: 8pt">Address_Suburb</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN
style="FONT-SIZE: 8pt">State</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN
style="FONT-SIZE: 8pt">memType</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN style="FONT-SIZE: 8pt">Fees
$</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN
style="FONT-SIZE: 8pt">Gender</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN style="FONT-SIZE: 8pt">Boat Storage Fees
$</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 18.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; 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"
align=center><SPAN><B><SPAN style="FONT-SIZE: 8pt">Total Fees Due
$</SPAN></B></SPAN><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 8pt"></SPAN></B></P></TD></TR>
<TR style="MIN-HEIGHT: 12.55pt">
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=98>
<P style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt"><SPAN><SPAN
style="FONT-SIZE: 9pt">Sue Trowsdale</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=71>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN
style="FONT-SIZE: 9pt">Suzy</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=125>
<P style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt"><SPAN><SPAN
style="FONT-SIZE: 9pt">21 Mountain Rd Rosebud</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=60>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">VIC</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=71>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">Senior</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">250.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN style="FONT-SIZE: 9pt">F</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">125.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">375.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD></TR>
<TR style="MIN-HEIGHT: 12.55pt">
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=98>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN style="FONT-SIZE: 9pt">Jon
Ross</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=71>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN
style="FONT-SIZE: 9pt">Wahoo</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=125>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN style="FONT-SIZE: 9pt">64
View Rd McCrae</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=60>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">VIC</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=71>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">Junior</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">140.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN style="FONT-SIZE: 9pt">M</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN style="FONT-SIZE: 9pt">–</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">140.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD></TR>
<TR style="MIN-HEIGHT: 12.55pt">
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 73.7pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=98>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN
style="FONT-SIZE: 9pt">Harry Wilson</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=71>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN
style="FONT-SIZE: 9pt">Victor</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 93.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=125>
<P style="MARGIN-BOTTOM: 2pt"><SPAN><SPAN style="FONT-SIZE: 9pt">35
Shady Ln Rosebud</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 44.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=60>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">VIC</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 53.35pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=71>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">Life</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN style="FONT-SIZE: 9pt">–</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN style="FONT-SIZE: 9pt">M</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">125.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; MIN-HEIGHT: 12.55pt; PADDING-LEFT: 5.4pt; WIDTH: 42.5pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=57>
<P style="TEXT-ALIGN: center; MARGIN-BOTTOM: 2pt"
align=center><SPAN><SPAN
style="FONT-SIZE: 9pt">125.00</SPAN></SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 9pt"></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-AU></SPAN> </P>
<P style="TEXT-ALIGN: right; MARGIN-BOTTOM: 5pt" align=right><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt">2 marks</SPAN></P>
<P
style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 21.3pt; MARGIN-RIGHT: 0cm"><B><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt"><SPAN>a.<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN></B><SPAN
style="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; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 22pt; MARGIN-RIGHT: 0cm"><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt"></SPAN> </P>
<P
style="TEXT-ALIGN: justify; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 22pt; MARGIN-RIGHT: 0cm"><SPAN
style="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; MARGIN-BOTTOM: 2pt; MARGIN-LEFT: 22pt; MARGIN-RIGHT: 0cm"><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt"> First </SPAN><SPAN
style="FONT-FAMILY: Wingdings; COLOR: #221e1f; FONT-SIZE: 10pt">o</SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt">
or Second </SPAN><SPAN
style="FONT-FAMILY: Wingdings; COLOR: #221e1f; FONT-SIZE: 10pt">o</SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt">
or Third </SPAN><SPAN
style="FONT-FAMILY: Wingdings; COLOR: #221e1f; FONT-SIZE: 10pt">o</SPAN><SPAN
style="COLOR: #221e1f; FONT-SIZE: 10pt"> </SPAN></P>
<P style="LINE-HEIGHT: 115%"><SPAN
style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt">____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________</SPAN></P>
<P style="LINE-HEIGHT: 115%"><SPAN
style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt">____________________________________________________________________________________</SPAN></P>
<P class=MsoNormal><SPAN
style="COLOR: #1f497d; FONT-SIZE: 11pt"></SPAN> </P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Laura Fihelly</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Teacher of Business
Management & Information Technologies</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Catholic Regional College
Sydenham</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">380 Sydenham Road
</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Sydenham 3037</SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">email: <A
href="mailto:fihl@crcsydenham.net"
target=_blank>fihl@crcsydenham.net</A></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">web: </SPAN><A
href="http://www.crcsydenham.net/"
target=_blank><SPAN>www.crcsydenham.net</SPAN></A><SPAN
style="COLOR: #1f497d"> </SPAN></P>
<P class=MsoNormal> </P></DIV></DIV></DIV>
<P></P>
<HR>
<P></P>_______________________________________________<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 and<BR><A
href="http://www.vitta.org.au"
target=_blank>http://www.vitta.org.au</A> - VITTA Victorian
Information Technology Teachers Association Inc
<P></P></BLOCKQUOTE></DIV><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 and<BR><A
href="http://www.vitta.org.au" target=_blank>http://www.vitta.org.au</A>
- VITTA Victorian Information Technology Teachers Association
Inc<BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>Mark Kelly<BR>Manager
of ICT, Reporting, IT Learning Area<BR>McKinnon Secondary College<BR>McKinnon
Rd McKinnon 3204, Victoria, Australia<BR>Direct line / Voicemail: +613 8520
9085, Fax +613 9578 9253<BR><A href="mailto:kel@mckinnonsc.vic.edu.au"
target=_blank>kel@mckinnonsc.vic.edu.au</A><BR>VCE IT Lecture Notes: <A
href="http://vceit.com" target=_blank>http://vceit.com</A><BR>Moderator: IT
Applications Edulist<BR><BR><FONT size=+0>All generalisations are false,
except this one.</FONT><BR><BR>
<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></BODY></HTML>