The Area being Modelled is :-
A General Design for an Insurance Database

Question: I am developing db 4 insurance association.

The db will enable member upload the transaction.

now a policy contain unique like policyno,effectivedate, expirydate, category where
category are motor, marine properties,etc

each category has different schema. eg motror store engineno,chasis no e.t.c. while
marine store shiptype e.tc the system will be used mainly 4 verification say by
engineno and it return whether the car is insured

with the detail.it will also give some statististal information like number of policy by category.

what will be the best db design
1) store the category information as xml
2)create seperate table for each category
3) any other idea


A. DESIGN NOTES :
From the User Requirements defined above, we can derive the following Business Rules :-
B. The Things of Interest, ('THINGS'), include :-
B.1 Cars
B.2 Insurance Policies.
B.3 Products.
B.4 Others to be determined.

C. These THINGS are Related as follows :-
C.1
C.2

D. Other Characteristics of these THINGS include :-
D.1

E. Sample Data includes :-
E.1

F. Typical Enquiries include :-
F.1