ThatJeffSmith

Tag: ERD

Entity Relationship Diagrams (ERD)

I have a nasty habit of not thinking. I take something for granted or assume something for so long, that it corrupts my original learning or understanding of a concept. And then when someone calls me out, my first reaction is to defend my ‘shortcut’ thinking instead of re-evaluating my set of assumptions. So I’ve […]

SQL Developer Data Modeler Quick Tip: Use SubViews

Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying […]

Reverse Engineer Views into an ERD

ERD – Fancy way of saying Entity-Relationship Diagram Since version 10.0 of Toad for Oracle, users have been able to select a table and have an ERD generated that automatically includes any related tables via Referential Integrity. However, what if you are trying to document a view which may bring in one or more other […]