Table Relationship Diagram
If you don’t have Designer6i or another CASE tool, you can develop your own SQL documentation. Sometimes I prefer to develop the documentation I use to write SQL by hand. Databases are often very complex and can have many tables. Yet, the majority of the queries I write come from a small subset of the database tables. I create a document that contains just the needed subset of the database tables. I place only the tables and relationships in the diagram in which I am interested. This special document is a useful device called a table relationship diagram.
The document is similar to a data schema diagram. It is a physical model of the relational tables within the database and contains all of the information necessary ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
