<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.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" vlink="purple">
<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 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="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;border:none">
<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>
</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 width="248" height="149" id="Picture_x0020_1" src="cid:image001.png@01CFFCFE.F8E00F40"><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>
</body>
</html>