Design Question - Additional Info

From: Tracy Rahmlow <Tracy.Rahmlow_at_aexp.com>
Date: Mon, 25 Jun 2001 12:48:05 -0700
Message-ID: <F001.0033728A.20010625125827@fatcity.com>

I think I may have confused some, regarding my previous post. The coverage and amount is specific to the vehicle. It is not a set amount. For example:

Method #1
Vehicle/Coverage Table
Seq Year Type Annual_Miles Comp_Ded Comp_Prem Towing_Ded Towing_Prem Pip_Ded Pip_Limit Pip_Prem

1    97   Jeep 1000      500       25.25           50        10        "NULL"
     "NULL"         "NULL"
2    99   Truck     7000      1000       20.50          "NULL"         "NULL"
     "NULL"         "NULL"         "NULL"
3              98   Car  5000      1000       15.00          0         30
250       100000         35

Method #2
Vehicle Table
Seq Year Type Annual_Miles
1 97 Jeep 1000
2 99 Truck 7000
3 98 Car 5000

Coverage Table

Seq  Covg_Id   Covg_Ded  Covg_Limit      Covg_Prem
1    A(Comp)   500       "NULL"          25.25
1    B(Towing) 50        "NULL"          10
2    A         1000      "NULL"          20.50
3    A         1000      "NULL"          15
3    B         0         "NULL"          30
3    C(Pip)         250       100000          35

The 1000 comp deductible does not equate to the same premium for all vehicles. We also have one coverage where 3 columns are necessary to capture the covg info. There is a deductible, limit and premium associated with it. So do we stick another column in the coverage table to capture for only this coverage? The saga continues. Now I understand when they say modeling is an art and not a science. I was much better in science. (Thus my struggles)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tracy Rahmlow
INET: Tracy.Rahmlow_at_aexp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 25 2001 - 14:48:05 CDT