Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database analyst mapping document

Status
Not open for further replies.

Jamfool

IS-IT--Management
Apr 10, 2003
484
GB
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.
 
I've found that Visio is good for presenting schemas documents. Depending on your DB, you may be able to get at least the table drawing done for you.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
it all depends on the DB.....most of the time I document things as I go.....inherited projects are crappy deal....

eg. Access has relationships tool while FileMaker(you by opening every file) has to check every file's relationship (AND all the tables are different files...at least until new V comes out).....
all the best to you!

> need more info?
:: don't click HERE ::
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top