Relational Insurance Model Using ACORD Standards

In the example described in these pages, the insurance related data is stored in a relational database, the relevant tables and primary key/foreign key relationships of which are illustrated in the following figure.

This model is clearly over-simplified, but it is complete enough to show the set of operations on ACORD messages that are at the core of our example. It comprises six tables:

• ACORD_PARTY
• ACORD_PERSON
• ACORD_ADDRESS
• ACORD_PHONE
• ACORD_POLICY
• ACORD_RELATION

Download SQL Scripts for this Relational Model

You can create this set of tables on your own system, which will allow you to run the examples on your own machine. To do this, download and execute the SQL scripts as described in Running the Examples on Your Machine.

What's Next

Go to XQuery Operation Examples for an ACORD Insurance Application to learn about the XQuery operations that are performed using the data in these tables by the ACORD application example described in these pages.