I would like to provide a non-technical, intuitive visualization of my database for people who are familiar with the underlying data, but not database design. 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 foreign and primary keys.
My goal is to convey a conceptual rather than a technical understanding of these relationships, and how they are a useful way of understanding the data itself. A technical and comprehensive description of the database will be provided as an appendix.
I see that there are many types of Entity-Relationship diagrams, but I am not sure which one, if any is best suited for explaining a data model to my audience. Perhaps there is another approach.
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.
update: but please note that I am not looking for a way to create such an ER diagram. I am looking for something further abstracted, that avoids dependency on keys.
Here is a very rough sketch of an idea: it uses overlap to show hierarchy and a bold border on the key table, and to show the 'ideal' level of abstraction (if it could contain and communicate the important information). Hopefully, these points can expand the scope of possible solutions. It is a 'sketch' in that I haven't figured out how to map these visual elements to specific relationships.