Database relationship tool needed

AI Thread Summary
The discussion centers around the need for efficient documentation of database tables, specifically for a Sybase database. The user seeks freeware options for creating diagrams that illustrate table structures and relationships, expressing a desire to avoid manual documentation. A suggestion is made to consider a trial version of Erwin, which may meet their requirements. The user has already developed a program to extract column information but notes that obtaining definitions for the tables remains a challenge, as it would require extensive additional documentation.
Borg
Science Advisor
Gold Member
Messages
2,270
Reaction score
4,888
I just got handed an assignment to document our database tables. I would rather not have to do this manually and I'm wondering if anyone knows of any freeware that will allow me to create diagrams of the tables and relationships between the tables.
 
Technology news on Phys.org
Which RDBMS do you use? A trial version of Erwin might do everything that you need.
 
Last edited:
Math Is Hard said:
Which RDBMS do you use? A trial version of Erwin might do everything that you need.

Thanks MIH, I'll look into it. We're using a Sybase database. I've already written a quick program to pull all of the needed column info for each of the tables. Except for the definitions, that will kill an entire appendix.
 
Thread 'Is this public key encryption?'
I've tried to intuit public key encryption but never quite managed. But this seems to wrap it up in a bow. This seems to be a very elegant way of transmitting a message publicly that only the sender and receiver can decipher. Is this how PKE works? No, it cant be. In the above case, the requester knows the target's "secret" key - because they have his ID, and therefore knows his birthdate.
Thread 'Project Documentation'
Trying to package up a small bank account manager project that I have been tempering on for a while. One that is certainly worth something to me. Although I have created methods to whip up quick documents with all fields and properties. I would like something better to reference in order to express the mechanical functions. It is unclear to me about any standardized format for code documentation that exists. I have tried object orientated diagrams with shapes to try and express the...

Similar threads

Replies
50
Views
7K
Replies
6
Views
2K
Replies
6
Views
2K
Replies
8
Views
2K
Replies
1
Views
3K
Replies
5
Views
2K
Back
Top