<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Normalisation</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff size=2>Hi
Roz:</FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2><<<FONT color=#000000>Would it be shockingly bad behaviour just to
stuff everything into one table??</FONT>>></FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff size=2>Not if
there is only one contact instance... </FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff size=2>The
application I worked was designed like so: The call request was comprised of two
tables...</FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff size=2>-
The first table had only two fields, the call number and the call
status. </FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff size=2>- The
second table had all the other fields for the rest of the
detail. </FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff size=2>In
many cases there was only one record in each table related to a specific
call. But another record was created if the call was not closed
because it was not resolved at one time or was escalated. Then each
follow-up record connected to the initial record. One to many. Does this
help?</FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=970324712-17032003><FONT face=Arial color=#0000ff
size=2>Jim</FONT></SPAN></DIV></BODY></HTML>