- Many-to-many relationships: use an associative (join) table ([link](https://community.dbdiagram.io/t/tutorial-many-to-many-relationships/412)). Try SchemaCrawler to create an ERD diagram if needed. See example [here](https://blog.stefanproell.at/2016/01/11/create-an-er-diagram-of-an-existing-sqlite-database-or-manyoother-rdbms/). You'll need to [install Java](https://java.com/en/download/manual.jsp) and add to your PATH. #rough