How many to many relationship on same table looks like in UML
I have a problem with understanding many to many relationships on the same table in UML.
A user in my database has permission which says who he is (an instructor or a student).
My problem is that I have an instructor who can have 0 or more students and a student who can have 0 or more instructors.
My idea is this:
I am not sure If is it correct. Is there any better solution?
Thanks for your help all :)
It depends what do you want to achieve.
If you're trying to build a documentation of your database using UML then your model will not differ from what you would do using e.g. crowfoot notation. In such case, your diagram is correct.
To emphasise the relationship you may use an association class linking User with User. It's bringing value only if your association class brings any additional value (attributes), otherwise, you can use a simple association.
If you're focusing on showing the actual dependencies rather than what you have in your database, you may consider having User as a parent to two classes Teacher and Student and then depict your association as on between Teacher and Student rather than between Users.
- Is better use an empty value as a '' or as NULL?
- How to show the result when I click the submit button? (Like View history)
- Split a string with no delimiters into columns
- Django complex partitioning & ordering for tree Table
- Laravel Database Insert Error in artisan tinker
- In MongoDB's pymongo, how do I do a count()?
- Optimizing MariaDB Query When Re-Querying Same Table
- Simple export and import of a SQLite database on Android
- How to visualize database tables in postgresql using pgAdmin?
- how to solve django.db.utils.NotSupportedError in django
- Watching a table for change in MySQL?
- Reversing the order of column names that contain both numbers and letters in R
- conceptual diagram abstraction and null values
- is there a MYSQL tables schema for storing raw material, intermediate and final products?
- Postgre join query not using expected index
- How can I get partial participation of both entities in 1:1 relationship
- mutate columns in R that start with a particular letter - converting character to numeric
- How to show full definition of function or procedure?
- What is the maximum number of connections for a SQLite3 database?
- Automate the Snowflake reports to email
- MySQL: Cloning a MySQL database on the same MySql instance
- Fixing all sequences in PostgreSQL 15 after migrating with logical replication from PostgreSQL 11
- What are the main differences between Redis/Valkey Pub/Sub and Streams?
- How to retrieve the last autoincremented ID from a SQLite table?
- All data is become NULL when run Update Query MySQL
- Execute SQL from file in SQLAlchemy
- How can I write a trigger and function to insert data into table2 when a new row is inserted into table1, while avoiding duplicates in table2?
- Using Django to visualise scraped data
- i'm having trouble creating the database using symfony framework
- Display data from state with React Typescript