This shared library showcases how to effectively use the Notion API to power a site as a content managemens system. I found the examples really helpful in showcasing creative ways to use the API.
I watched this video while researching an answer posted to reddit. The workflow that is built uses tabs and different database views to achieve one-to-one and one-to-many relationships in a workflow.
I'm always looking for better ways to manage projects inside of Notion. Matthias' guide walks through a lot of common patterns that I had to discover on my own when I started.