- 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 [[entity-relationship 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]] and add to your [[PATH]]. #rough