<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Normalisation</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hey all</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have a bit of a funny database spec for a call centre application (callers ringing to register insurance claims).</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">The details taken from the customer cover a lot of different entities; the caller, their insurance policy, their car, the accident, the third party, the third party's car, the third party's insurance policy etc. My instinct is to create a table for each distinct entity. However, they will all have 1:1 relationships as there is only one instance of each entity per claim (the caller I would hold separate as we may handle more than one claim for them). This is a fairly 'disposable' (i.e. expected to be used only in the short term and never to be expanded) app. Would it be shockingly bad behaviour just to stuff everything into one table??</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Roz</FONT>
</P>
</BODY>
</HTML>