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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
