2
1 Comment

Let me model an entity relationship diagram of your app or idea

Hey guys,
I'd like you to offer to create an entity relationship diagram of your app or idea. In exchange I'd like to reuse your app or idea requirements to get trainees better in ER modeling.

How it works

I'll take a maximum of 10 replies - if there is any interest in it at all.

  • You let me know your software requirements or mockups as far as you are able to share it. Put a link to your Google Docs document or assets into this thread and how I can get in contact with you. Please keep your requirements on one DIN A4 page ;-)
    Describe your audience and type of app in one or two sentences (e.g. on-premises app for doctors).
    I promise, your mail address won't be used for newsletter stuff or spamming.
  • I'll model your database schema.
  • You'll receive the diagram and SQL schema. You can do whatever you want with it: Compare the solution against your current implementation, use it as a starting point for your upcoming developments or as an idea how to migrate your NoSQL schema to a relational schema.
  • I can reuse your requirements or mockups in my exercise newsletter. Please don't share any confidential information in your requirements. If you have already build an app, I'll add a link to your homepage in the exercise. Free marketing here, audience consists of upcoming software developers :-)

How it looks like

Here is an exercise about modeling parts of Twitch's database: https://imgur.com/a/n0uDOfg

FYI: It's not about rebuilding Twitch's whole database but about identifying requirements from a screenshot, a document or a CSV file.

Background

I am currently collecting a bunch of software requirements for my trainees, so they get better in modeling ER diagrams. ER diagrams are a central part of their final exams to "Fachinformatiker Anwendungsentwicklung". Here in Germany it is an official training to become a software developer.

Most of the trainees are good at writing software but they are neither confident in identifying requirements nor in modeling the persistence layer.
Trainees are much more interested into the topic when having real-world examples, instead of modeling the third library or shop database. I've already a long list of exercises but I want to give something back to the IH community .

To make them better in database modeling, the trainees receive a weekly mail with an exercise like the Twitch example above.

Disclaimer

I am not sure if this is the fitting group or "Growth" might be more appropriate. If it does not fit, can one of the mods move this post to the appropriate group?

  1. 1

    Thank you for the offer. I wish I could help, but my product does not fit well into ERD.

Trending on Indie Hackers
I talked to 8 SaaS founders, these are the most common SaaS tools they use 20 comments What are your cold outreach conversion rates? Top 3 Metrics And Benchmarks To Track 19 comments How I Sourced 60% of Customers From Linkedin, Organically 12 comments Hero Section Copywriting Framework that Converts 3x 12 comments Promptzone - first-of-its-kind social media platform dedicated to all things AI. 8 comments How to create a rating system with Tailwind CSS and Alpinejs 7 comments