Displaying inheritance on ER Diagrams?
In my Spring Boot app, I have an entity relationship diagram as shown below and looking for a proper way for displaying inheritance on it. I have a look at dozens of pages, but could not find any example (most of them use different kind of diagrams).
Normally I use the annotations to show one-to-many- etc. relationships as shown between student-course and course-professor. But I am not sure it the arrows filled and empty is a proper way to display inheritance between User - Student and User - Professor.
How should I display inheritance properly for an ER Diagram (not class, etc.)?
The ER modeling technique typically does not include any inheritance feature. There are several ways to extend the technique, but there is no single way how you should model inheritance.
UML is a popular modeling language, which does not have the crow's foot notation as used in your example, but it does have an inheritance symbol. If you want to borrow that: it is like the arrow you have drawn between User and Student: an arrow with an empty triangle at the end, pointing from the special entity to the more general entity.
- How to know relations between tables
- Is it possible to delete unreferenced objects automatically in Core Data?
- Are associations classes in class diagrams like weak entities in ERD?
- Insert inserted id to another table
- UML Class Diagram Multiplicity and ER Diagrams Cardinality
- ER (Entity Relationship) Diagram == Relational Schema Database?
- Tool for convert SQL code to diagram
- Adding relationship to an Entity couses weird ORM mapping error
- What's diference between entity-relationship and domain-model
- Mermaid ER diagram styling
- Laravel ER diagram generator getAllModelsFromEachDirectory()
- An associative Entity with optional participation on one side and mandatory participation on the other
- SQLAlchemy ER diagram in python 3
- pgadmin 4 (or db visualiser) entity relation diagram
- How to generate SQLite entity relationship diagram from database file
- ERD - How to model a relation between two entites with a third entity as "attribute"
- Displaying inheritance on ER Diagrams?
- How can I create two one-to-many relationships between two tables with the same Primary Key in Power BI?
- Entity Relationship Diagram for MS Access
- Difference between entity and relation in UML and SQL
- Symfony 5: ManyToMany Relationship Not Persisting When Added from MappedBy Side Without 'by_reference' => false
- Implement FK constraints as depicted in ER-diagram
- is optionality (mandatory, optional) and participation (total, partial) are same?
- Entity Relationship Diagram or Class Diagrams
- Sqlite foreign key mismatch?
- Is the quaternary relationship in this er diagram correct?
- ERD for website that sells machines and lets you download a mobile app that controls them
- How to show partial key in UML ER diagram
- IS Relation in Java
- Model relationships in ASP.NET MVC