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."