I would like to provide an intuitive visualization of my database for readers and users of the database that does not require technical knowledge of database structure. The figure will be included in a journal article, and the audience is primarily students and scientists, many of whom will not understand concepts such as "many to many" or keys. My goal is to convey the contents of the database with some insight into these relationships, but to convey a conceptual understanding rather than a technical one. A technical and comprehensive description of the database will be provided as an appendix, in the documentation.
I see that there are many types of ER diagram, but I am not sure which one, if any is best suited for explaining a data model to my audience.
How can I represent this in a non-technical way that avoids keys and provides a more intuitive understanding of the relationships among tables?
Here is an example of my starting point:
The actual database will have 11 tables, including 3 used to define many-to-many relationships, and many fields that can be dropped.
How can I represent ... the relationships among tables?
Where the line is between statistical visualization and mere illustrations of relationships (or simple diagrams) I'm not sure though. IMO it is close enough to stay open. $\endgroup$