<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16584"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-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 bgColor=#ffffff vLink=purple link=blue>
<DIV><FONT size=2 face=Arial>Normal form of course!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial><hangs_head_in_shame></FONT></DIV>
<DIV><FONT size=2 face=Arial>Sorry</FONT></DIV>
<DIV><FONT size=2 face=Arial></hangs_head_in_shame></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Robert Hind<BR>Retired<BR>Ex Traralgon and
Ashwood</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=savage.john.l@edumail.vic.gov.au
href="mailto:savage.john.l@edumail.vic.gov.au">Savage, John L</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> Friday, November 07, 2014 11:41
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Third
Normal Form</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">What
form will their Normal curve take?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Laurie
Savage<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><A
href="http://accelerus.pvgc.vic.edu.au">http://accelerus.pvgc.vic.edu.au</A><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US> <A
href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</A>
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Mark
Scott<BR><B>Sent:</B> Thursday, 6 November 2014 3:38 PM<BR><B>To:</B> Year 12
IT Applications Teachers' Mailing List<BR><B>Subject:</B> Re: [Year 12 IT
Apps] Third Normal Form<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US">Absolutely
correct (so far)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US">Let’s
hope they don’t up the ante with this question in an attempt to get their
normal curve.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US">Mark
Scott<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US">Luther
College<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">
<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"> </SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt; mso-fareast-language: EN-US"><o:p></o:p></SPAN></P>
<TABLE style="WIDTH: 300pt" class=MsoNormalTable border=0 cellSpacing=0
cellPadding=0 width=400>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; PADDING-TOP: 0cm">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #184689; FONT-SIZE: 10pt">Mark
Scott </SPAN></B><B><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #184689; FONT-SIZE: 7.5pt"><BR></SPAN></B><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #184689; FONT-SIZE: 9pt">Daily
Administrator<BR></SPAN><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: white; FONT-SIZE: 5.5pt">Luther</SPAN><o:p></o:p></P>
<DIV>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #808285; FONT-SIZE: 9pt">Plymouth
Road<BR>Croydon Hills Victoria 3136<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: white; FONT-SIZE: 5.5pt">Luther</SPAN><o:p></o:p></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #808285; FONT-SIZE: 9pt">Telephone
(03) 9724 2000<BR>Direct Line (03) 9724 2023 <o:p></o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #808285; FONT-SIZE: 9pt"><A
href="http://www.luther.vic.edu.au/"><SPAN
style="COLOR: #808285; FONT-SIZE: 10pt; TEXT-DECORATION: none">www.luther.vic.edu.au</SPAN></A>
<o:p></o:p></SPAN></P></DIV></DIV></TD>
<TD
style="PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; PADDING-TOP: 0cm">
<P class=MsoNormal><A href="http://www.luther.vic.edu.au/"><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; TEXT-DECORATION: none"><IMG
id=luther border=0 name=luther alt="Luther College"
src="cid:DB3F15345C504D9587C95FBDA2C7DAFF@robertPC" width=143
height=143></SPAN></A><o:p></o:p></P></TD></TR></TBODY></TABLE>
<DIV style="MARGIN-TOP: 7.5pt; FLOAT: left">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #ca003a; FONT-SIZE: 7pt">Please
consider the environment before printing this email.</SPAN></B><o:p></o:p></P>
<P style="LINE-HEIGHT: 110%; MARGIN-TOP: 3.75pt"><SPAN
style="LINE-HEIGHT: 110%; FONT-FAMILY: 'Arial','sans-serif'; COLOR: #808285; FONT-SIZE: 7pt">This
email and any attachments may contain privileged and confidential information.
<BR>If you are not the intended recipient you may not distribute or reproduce
this email <BR>or attachments. If you have received this message in error
please notify us by return mail.<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><BR clear=all><o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #e1e1e1 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; FONT-SIZE: 11pt" lang=EN-US> <A
href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</A>
[<A
href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</A>]
<B>On Behalf Of </B>Matheson, Heath A<BR><B>Sent:</B> Thursday, 6 November
2014 3:19 PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing
List<BR><B>Subject:</B> Re: [Year 12 IT Apps] Third Normal
Form<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">For
normalisation I talk about three problems you can have with databases and why
they are problems.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt" class=MsoListParagraph><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">1.</SPAN><SPAN
style="COLOR: #1f497d; FONT-SIZE: 7pt">
</SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Too
many “things” in one field, which makes it hard to search and
sort.<o:p></o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt" class=MsoListParagraph><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">2.</SPAN><SPAN
style="COLOR: #1f497d; FONT-SIZE: 7pt">
</SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Data
repeated in many rows which means if something changes such as a customer
address you need to change it in lots of places.<o:p></o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt" class=MsoListParagraph><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">3.</SPAN><SPAN
style="COLOR: #1f497d; FONT-SIZE: 7pt">
</SPAN><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Tables
that contain calculated values which take up processing power and unnecessary
storage space if you have a really, really large
database.<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 18pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 18pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">0NF
– has all the problems<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 18pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">1NF
– eliminate problem 1 (separate the data)<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 18pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">2NF
– eliminate problem 1 and 2 (make multiple tables, add primary keys and link
them)<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 18pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">3NF
– eliminate all three problems. (eliminate calculated fields, put them in
queries and reports)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I
think that’s all they need to know based on the VCAA examination reports so
far. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Good
luck to all your students!<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Heath
Matheson<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Mount
Beauty Secondary College<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US> <A
href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</A>
[<A
href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</A>]
<B>On Behalf Of </B>ken price<BR><B>Sent:</B> Wednesday, 5 November 2014 10:40
AM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing
List<BR><B>Subject:</B> Re: [Year 12 IT Apps] Third Normal
Form<o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal>It's not often that I'd consider normalisation as a source
of interesting reading, but this is rather good. Well done Mark - hopefully
this will help others, or at least provide a direct example they can
use. <o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>Is it OK for it to be re-used elsewhere with
acknowledgement?<o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal>Ken Price<o:p></o:p></P></DIV></DIV></DIV></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal>On Wed, Nov 5, 2014 at 10:20 AM, Mark <<A
href="mailto:mark@vceit.com" target=_blank>mark@vceit.com</A>>
wrote:<o:p></o:p></P>
<DIV>
<P class=MsoNormal>Hello workers.<o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>In case anyone was waiting for the other shoe to drop,
let's cover 3NF.<o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>To achieve 3NF:<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal>- You must have already achieved 1NF and
2NF.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal>- No non-key field may be dependent on another non-key
field.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>Another way of saying it is that every non-key field in a
table must give some information about the primary key rather than any other
key in the table. Any field that does not contribute to the description of the
primary key must be removed from the table.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>For example... take a table. StudentID+SubjectID together
are the primary key. (BTW - this use of multi-field keys is always to be
avoided in the real world, but never mind for now.)<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>Honours is a Boolean field that is True if Mark is A or
above, and False otherwise.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'">StudentID
SubjectID Mark Honours</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'">ABC0001
S01 A
True </SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'">ABC0001
S02 A+
True</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'">DEF0002
S01 B
False</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">The Honours
field is dependent on the Mark field (i.e. to find the meaning of the Honours
field, you need to refer to the Mark field) - but the Mark field is not the
table's primary key. i.e. The Honours field describes the mark, not the
student+subject.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">So, a
non-key field (Honours) is dependent on another non-key field (Mark). So it
fails 3NF.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">To fix it,
do the same as we did before to achieve 2NF... break the offending field away
into its own table with its own primary key (Mark) and non-key field (Honours)
and relate the new table to the existing one using Mark as the link
field.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">This 3NF
scenario looks VERY much like the 2NF before, doesn't
it? </SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">The only
difference is that 2NF needed a non-key field to relate to the entire set of
fields acting as the primary key.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">In 3NF,
it's actually simpler - a non-key field must not be dependent on another
non-key field. In both cases, the fix is the same: table
splitting. </SPAN>In my opinion, 3NF should be called 1.5NF because it
seems to be more basic that 2NF, but we must all revere the word of
Codd.<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">Always
remember the normalisation oath:</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'">The key
(1NF), the whole key (2NF) and nothing but the key (3NF), so help me </SPAN><A
href="http://en.wikipedia.org/wiki/Edgar_F._Codd" target=_blank><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'">Codd</SPAN></A><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'">.</SPAN><o:p></o:p></P></DIV>
<DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal>(It's taken me 4 years, but I think I'm <I>finally</I>
getting the hang of normalisation).<o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="COLOR: #888888"><o:p> </o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN class=hoenzb><SPAN style="COLOR: #888888">--
</SPAN><o:p></o:p></SPAN></P>
<DIV>
<DIV>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="COLOR: #888888">Mark
Kelly<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="COLOR: #888888">mark AT vceit DOT
com<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="COLOR: #888888"><A href="http://vceit.com"
target=_blank>http://vceit.com</A><o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="COLOR: #888888"><o:p> </o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><I><SPAN style="COLOR: #888888">I love the sound of
people's voices after they stop talking.</SPAN></I><SPAN
style="COLOR: #888888"><o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="COLOR: #888888"><o:p> </o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="COLOR: #888888"><o:p> </o:p></SPAN></P></DIV></DIV></DIV></DIV></DIV></DIV>
<P class=MsoNormal><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 <br><BR><A
href="http://www.vitta.org.au" target=_blank>http://www.vitta.org.au</A>
- VITTA Victorian Information Technology Teachers Association Inc
<br><BR><A href="http://www.swinburne.edu.au/ict/schools"
target=_blank>http://www.swinburne.edu.au/ict/schools</A> - Swinburne
University<o:p></o:p></P></DIV>
<P class=MsoNormal><BR><BR clear=all><o:p></o:p></P>
<DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV>
<P class=MsoNormal>-- <o:p></o:p></P>
<DIV>
<P class=MsoNormal>-- <BR>Dr Ken Price MACS CP ACCE Professional
Associate.<BR>President, TASITE <A href="http://www.tasite.tas.edu.au"
target=_blank>http://www.tasite.tas.edu.au</A><o:p></o:p></P></DIV></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>
<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
<br><BR>http://www.vitta.org.au - VITTA Victorian Information
Technology Teachers Association Inc
<br><BR>http://www.swinburne.edu.au/ict/schools - Swinburne
University</BLOCKQUOTE></BODY></HTML>