I have a situation where we have several converted legacy apps that are maintaining 1-1 relationships, in some cases between up to 5 tables.

The tables are not in a DBC, and integrity does not appear to checked with much frequency.

Anyone got any ideas on ways to improve this situation ( tips, code etc. ) The most obvious way I can see is to lump all the fields together into a single table and share it between the apps ( this leaves a huge field redundancy ).

Any help is appreciated,

Craig.