<html 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" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[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.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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 bgcolor="white" lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Thanks Robert, that’s pretty much what I was thinking. My students have a problem with a primary key being more than one column, probably because Access table design really enforces a single column, record number
style of design. A logical PK would be along the lines of CUSTID+PHONE i.e. both/all fields of the table but then there would be no datum that was uniquely dependent on the PK unless we add an unnecessary
<i>Comments</i> field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Laurie<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU"> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Robert Timmer-Arends<br>
<b>Sent:</b> Monday, 10 November 2014 6:00 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] 3NF: Request for clarification<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Hello Laurie</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">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</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">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?
</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">If this is the intention, then you are right: phone number is dependent on the meaningless ID and we have 3NF.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">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.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">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.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">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.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">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.</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Regards</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Robert T-A</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU">----- Original Message -----
<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid black 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="background:#E4E4E4"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">
<a href="mailto:savage.john.l@edumail.vic.gov.au" title="savage.john.l@edumail.vic.gov.au">
Savage, John L</a> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">To:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">
<a href="mailto:itapps@edulists.com.au" title="itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing List</a>
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Sent:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"> Monday, November 10, 2014 3:55 PM<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU">Subject:</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-language:EN-AU"> [Year 12 IT Apps] 3NF: Request
for clarification<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</div>
<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 valign="top" style="padding:.75pt .75pt .75pt .75pt">
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td colspan="3" style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Tournament Winners<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><u><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Tournament</span></u></b><b><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p></o:p></span></b></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><u><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Year</span></u></b><b><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p></o:p></span></b></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Winner<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Indiana Invitational<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">1998<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Al Fredrickson<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Cleveland Open<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">1999<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Bob Albertson<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Des Moines Masters<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">1999<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Al Fredrickson<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Indiana Invitational<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">1999<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Chip Masterson<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Here is my problem<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td width="120" colspan="3" valign="top" style="width:90.0pt;border:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Customer<o:p></o:p></span></p>
</td>
<td width="40" rowspan="4" valign="top" style="width:30.05pt;border:none;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="184" colspan="3" valign="top" style="width:138.15pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Phone<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="40" valign="top" style="width:29.95pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">ID<o:p></o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SN<o:p></o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">FN<o:p></o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">RecordNo<o:p></o:p></span></p>
</td>
<td width="51" valign="top" style="width:38.55pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">ID_FK<o:p></o:p></span></p>
</td>
<td width="54" valign="top" style="width:40.8pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Phone<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="40" valign="top" style="width:29.95pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SAV01<o:p></o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Savage<o:p></o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Laurie<o:p></o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">1<o:p></o:p></span></p>
</td>
<td width="51" valign="top" style="width:38.55pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SAV01<o:p></o:p></span></p>
</td>
<td width="54" valign="top" style="width:40.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">043123456<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="40" valign="top" style="width:29.95pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SMI05<o:p></o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Smith<o:p></o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Sam<o:p></o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">2<o:p></o:p></span></p>
</td>
<td width="51" valign="top" style="width:38.55pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SAV01<o:p></o:p></span></p>
</td>
<td width="54" valign="top" style="width:40.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">0393062512<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="40" valign="top" style="width:29.95pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border:none;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">3<o:p></o:p></span></p>
</td>
<td width="51" valign="top" style="width:38.55pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SMI05<o:p></o:p></span></p>
</td>
<td width="54" valign="top" style="width:40.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">0438111222<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="40" valign="top" style="width:29.95pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border:none;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">4<o:p></o:p></span></p>
</td>
<td width="51" valign="top" style="width:38.55pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SMI05<o:p></o:p></span></p>
</td>
<td width="54" valign="top" style="width:40.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">0396541782<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="40" valign="top" style="width:29.95pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="40" valign="top" style="width:30.05pt;border:none;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">5<o:p></o:p></span></p>
</td>
<td width="51" valign="top" style="width:38.55pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">SMI05<o:p></o:p></span></p>
</td>
<td width="54" valign="top" style="width:40.8pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">0412345678<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU"><o:p></o:p></span></p>
</td>
<td valign="top" style="padding:.75pt .75pt .75pt .75pt">
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Winner Dates of Birth<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><u><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Winner</span></u></b><b><span style="font-size:12.0pt;mso-fareast-language:EN-AU"><o:p></o:p></span></b></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Date of Birth<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Chip Masterson<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">14 March 1977<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Al Fredrickson<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">21 July 1975<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;mso-fareast-language:EN-AU">Bob Albertson<o:p></o:p></span></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:12.0pt;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:12.0pt;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 border="0" width="248" height="149" id="Picture_x0020_1" src="cid:image001.png@01CFFD8C.55FF57C0"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o: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.<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-AU">_______________________________________________<br>
<a href="http://www.edulists.com.au">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">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">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<o:p></o:p></span></p>
</blockquote>
</div>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.</p>
</body>
</html>