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