- Home
- Database Design Tools
- ER Designer
ER Designer
What it is
ER Designer is a browser-based platform for creating entity-relationship diagrams, restructuring database schemas, and generating logical schemas. The editor handles entities, attributes, keys, composite and multivalued attributes, relationships, and generalizations in Classic, Oval, or Tabular styles. A guided wizard identifies issues such as missing keys, multivalued attributes, and ISA structures, then proposes step-by-step solutions. From a restructured diagram, users can generate tables, primary keys, foreign keys, and crow’s foot notation. Diagrams import and export as JSON and export as PDF or PNG. Teachers can create classes, attach exercises, monitor submissions, and review student projects read-only. Students join with a code or invitation and submit work. Anonymous whiteboards are available, but saving projects on the server requires sign-in. Student and Teacher plans are free. Institute / Department pricing is on request, with multiple teachers, centralized user management, and dedicated onboarding. Teacher access requires administrator review of a profile request.
For and against
For
- Supports multiple ER diagram styles
- Wizard guides schema restructuring decisions
- Generates tables and key relationships
- Imports and exports JSON diagrams
- Free Student and Teacher plans
Against
- Server saving requires signing in
- Teacher access needs administrator approval
- SQL export is not available
- Institute pricing is on request
The verdict
ER Designer combines diagram editing, schema restructuring guidance, logical-schema generation, and classroom workflows. Its free education plans make it accessible, while teams should note the missing SQL export and sign-in requirement for saved work.
Who it suits
ER Designer suits teachers, students, independent users, and business database design teams working in a browser. It is also useful for classes that need assignments and submission monitoring.
Plans and prices
Student
Access teacher's classes · Full editor · Exercise submission
Read 10 Oct 2026 · ermap.io
Teacher
Create and manage classes · Assign work with attachments · Monitor submissions and progress
Read 10 Oct 2026 · ermap.io
Institute / Department
Multiple teachers · Centralized user management · Dedicated onboarding
Read 10 Oct 2026 · ermap.io
On the record
- Anonymous use
- The site says users can open an anonymous whiteboard, but signing in is required to save projects on the server.ermap.io · read 10 Oct 2026
- Diagram elements
- The editor supports entities, attributes, keys, composite and multivalued attributes, relationships and generalizations.ermap.io · read 10 Oct 2026
- Diagram styles
- It offers Classic, Oval and Tabular diagram styles.ermap.io · read 10 Oct 2026
- Guided restructuring
- A wizard highlights issues such as missing keys, multivalued attributes and ISA structures, then proposes step-by-step solutions.ermap.io · read 10 Oct 2026
- Import and export
- Users can import and export diagrams as JSON and export diagrams as PDF or PNG.ermap.io · read 10 Oct 2026
- Integrations and login
- Users can sign in with email and password or through Google or GitHub OAuth.ermap.io · read 10 Oct 2026
- Intended users
- The site describes the tool for teachers, students, independent users and business database design teams.ermap.io · read 10 Oct 2026
- Logical schema
- It can generate tables, primary keys, foreign keys and crow's foot notation from a restructured diagram.ermap.io · read 10 Oct 2026
- Maker
- The site identifies Di Menna Riccardo as the software's creator.ermap.io · read 10 Oct 2026
- Purpose
- ER Designer is a browser-based platform for creating ER diagrams, restructuring database schemas and generating logical schemas.ermap.io · read 10 Oct 2026
- Role activation
- Teacher access requires a profile request in account settings that is reviewed by an administrator.ermap.io · read 10 Oct 2026
- Student workflow
- Students can join classes with a code or invitation, access assigned work and submit exercises.ermap.io · read 10 Oct 2026
- Support
- The help page invites bug reports and improvement suggestions through a feedback form.ermap.io · read 10 Oct 2026
- Teaching tools
- Teachers can create classes, assign exercises with attachments, monitor submissions and review student projects read-only.ermap.io · read 10 Oct 2026
