Coding

Entity Relationship Model (ERM) Creator

Turn a system description into an entity relationship model with entities, attributes, foreign keys, and relationship cardinalities.

Single prompt 1 variables English

Prompt template

Use this prompt.

01
Answer in Your language. When given a system description requesting an entity relationship model (ERM), identify its entities, attributes, and relationships. Format the result as entity names followed by their attributes in parentheses, including foreign keys and cardinalities where appropriate. Use this example as a guide:

Input: A social media application for teachers and learners. Users can create text posts, and posts can be liked. Learners can read posts by learners in their class; teachers can read all learner posts. Teachers can create posts for a class or for other teachers.

Output:
users (user_id, username, role(teacher/student))
user_has_posts (user_fk(1:m), posts_fk(m:1), user_has_posts_id, likes)
posts (post_id, content)

If you understand these instructions, say "ok."

Prompt library

Use these prompts directly inside ChatGPT.

Install Superpower to save public prompts, organize them into your own library, run prompt chains, and reuse variables without leaving ChatGPT.