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.
- Craig
"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson