O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required