Some Entity Relationship Diagrams (ERDs) are simple, while others are really complex. This article describes a few tools that can help you tackle both types of ERDs, as well as everything in between.
By Rafael Victória-Pereira
The first tool you’ll need sits right between your ears: your brain. There’s a lot to learn, and you’ll have to put your grey matter to use in this chapter. It’s also a good idea to review the Data Definition Language (DDL) part of SQL, because we’re going to revisit tables, views, indexes, constraints, and other DDL concepts. At some point, my SQL 101 TechTip series will touch on that, but for the time being, I’ll assume you’ve done your homework and are up to speed on these concepts.