What is the best way to visually share and communicate database schemas?
This is my new user name and profile picture on Quora!
I chose an image from my laptop at random |
- the contents of each table,
- the relationships between tables: primary keys, foreign keys,
- some exogenous information such as input data source.
I've become fond of Toad for Oracle as a tool for visually describing existing database schema. Toad could be described as an applications development environment, but it has an ERD creation function, which can be used to generate a nicely portable diagram in a choice of formats, certainly XLS and PNG, and possibly PDF.
In addition to the ERD, it is helpful to have a corresponding data dictionary in document form that lists, by table, the fields (and what they represent as descriptive naming isn't usually an option when field names are restricted to only 8 characters or similarly few bytes), field type and length. Toad generates such a document.
For a quick layout of something conceptual, try using MS Visio, or even MS Excel.
No comments:
Post a Comment
Comments might or might not appear immediately