Hello Iam currently trying to produce a document to show the relationships within a database.
The problem(s) I have are as follows:-
There are no foreign keys
Multiple different aliases for the same columns, throughout the database.
e.g client_code, code, Client_no, client_number
Columns have identical names to those in other tables even tho they do not relate to each other.
Limited documentation covering approximately 10% of the 250 tables used, with Very limited relationship documentation.
Therefore I was wondering if someone could recommend the most effective database mapping tool i can use that will aid me (rather than hinder) this work. I think that I will basically need to enter every relationship individually, as i cannot rely on reverse engineering packages.
The problem(s) I have are as follows:-
There are no foreign keys
Multiple different aliases for the same columns, throughout the database.
e.g client_code, code, Client_no, client_number
Columns have identical names to those in other tables even tho they do not relate to each other.
Limited documentation covering approximately 10% of the 250 tables used, with Very limited relationship documentation.
Therefore I was wondering if someone could recommend the most effective database mapping tool i can use that will aid me (rather than hinder) this work. I think that I will basically need to enter every relationship individually, as i cannot rely on reverse engineering packages.