<!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:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.23569"><!--[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:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
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";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
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-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU link=blue bgColor=#ffffff vLink=purple>
<DIV><FONT size=2 face=Arial>Hello Laurie</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Customer table: primary key = ID; no repeating
groups > 1NF; SN & FN are both dependent only on primary key >
2NF; neither SN or FN determine each other (ID is the only determinant) >
3NF</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Phone table: first, why have the 'record number'?
If it is an actual field then do you mean it to be a unique identifier? In other
words, an ID field? </FONT></DIV>
<DIV><FONT size=2 face=Arial>If this is the intention, then you are right: phone
number is dependent on the meaningless ID and we have 3NF.</FONT></DIV>
<DIV><FONT size=2 face=Arial>But, that is the same for any ID. Remember that the
primary key is the smallest set of columns that uniquely identify a row. The
reason we introduce an ID field is that in a table with many columns, the number
of columns that make up the primary key could become quite unwieldy. For your
Customer table, for example, if you did not have ID, then the primary key would
be SN+FN, and those two columns would have to be duplicated into any table you
wished to link to the Customer table.</FONT></DIV>
<DIV><FONT size=2 face=Arial>So, for the phone table - assuming it's going to be
the 'destination' of a link, why bother with the RecordNo field at all. The
primary key would be ID_FK + Phone, and 1NF, 2NF and 3NF are
achieved.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I know where you are coming from though - a few
months ago I was trying to come up with some simple examples and found that
reducing the table to two columns makes things very difficult for 2NF and 3NF.
In effect the problems that 2NF and 3NF are trying to fix just disappear so 2NF
and 3NF become pointless. The second thing that makes 2NF and 3NF 'disappear' is
the use of ID fields because the problems that 2NF and 3NF are trying to fix
only crop up when the primary key is made up of two or more
columns.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>So, examples that are trying to explain 2NF and 3NF
need multi-column primary keys and at least one more column than just the
primary key.</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></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; 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> Monday, November 10, 2014 3:55
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Year 12 IT Apps] 3NF: Request
for clarification</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal>I’ve been reading and re-reading material about 3NF and
trying to look at it as an average student (which is easy). My problem is
pretty simple and best dealt with by two examples.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>First, from Wikipedia is the classic example with which I
have no problems, the DOB is uniquely dependent on the key field
(Winner).<o:p></o:p></P>
<TABLE class=MsoNormalTable border=0 cellPadding=0>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
vAlign=top>
<TABLE class=MsoNormalTable border=0 cellPadding=0>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
colSpan=3>
<P style="TEXT-ALIGN: center" class=MsoNormal align=center><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Tournament
Winners<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><U><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Tournament</SPAN></U></B><B><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p></o:p></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><U><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Year</SPAN></U></B><B><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p></o:p></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Winner<o:p></o:p></SPAN></B></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Indiana
Invitational<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">1998<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Al
Fredrickson<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Cleveland
Open<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">1999<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Bob
Albertson<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Des Moines
Masters<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">1999<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Al
Fredrickson<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Indiana
Invitational<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">1999<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Chip
Masterson<o:p></o:p></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Here is my
problem<o:p></o:p></SPAN></P>
<TABLE
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; WIDTH: 100%; BORDER-COLLAPSE: collapse; BORDER-TOP: medium none; BORDER-RIGHT: medium none"
class=MsoTableGrid border=1 cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 90pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=120 colSpan=3>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Customer<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top rowSpan=4 width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 138.15pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=184 colSpan=3>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Phone<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 29.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">ID<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SN<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">FN<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 58.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=78>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">RecordNo<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 38.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=51>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">ID_FK<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 40.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=54>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Phone<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 29.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SAV01<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Savage<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Laurie<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 58.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=78>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">1<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 38.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=51>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SAV01<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 40.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=54>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">043123456<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 29.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SMI05<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Smith<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Sam<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 58.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=78>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">2<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 38.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=51>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SAV01<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 40.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=54>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">0393062512<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 29.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 58.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=78>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">3<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 38.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=51>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SMI05<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 40.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=54>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">0438111222<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 29.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 58.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=78>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">4<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 38.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=51>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SMI05<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 40.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=54>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">0396541782<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 29.95pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 30.05pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=40>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 58.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=78>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">5<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 38.55pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=51>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">SMI05<o:p></o:p></SPAN></P></TD>
<TD
style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 40.8pt; PADDING-RIGHT: 5.4pt; BORDER-TOP: medium none; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm"
vAlign=top width=54>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">0412345678<o:p></o:p></SPAN></P></TD></TR></TBODY></TABLE></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
vAlign=top>
<TABLE class=MsoNormalTable border=0 cellPadding=0>
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"
colSpan=2>
<P style="TEXT-ALIGN: center" class=MsoNormal align=center><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Winner Dates
of Birth<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><U><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Winner</SPAN></U></B><B><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p></o:p></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P style="TEXT-ALIGN: center" class=MsoNormal
align=center><B><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Date of
Birth<o:p></o:p></SPAN></B></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Chip
Masterson<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">14 March
1977<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Al
Fredrickson<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">21 July
1975<o:p></o:p></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">Bob
Albertson<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU">28 September
1968<o:p></o:p></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>These are in 3NF but in the Phones Table the phone number
is only UNIQUELY dependant on the <B>meaningless</B> record number, which
seems at variance with the “key and nothing but the key” motto OR is the key
RecordNo+ID_FK.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I’m definitely missing something in the definition aren’t
I?<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Laurie<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="mso-fareast-language: EN-AU"><IMG
id=Picture_x0020_1 src="cid:10C6024D55F84FE6A7448F75788E1591@timmerarends"
width=248 height=149><o:p></o:p></SPAN></P>
<P class=MsoNormal><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>