- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
One-to-Many or Many-to-One Relationship in DBMS
A relationship can be One-to-Many or Many-to-One in DBMS. Let us see what that means with examples −
One-to-Many relationship in DBMS is a relationship between instances of an entity with more than one instance of another entity.
The relation can be shown as −
Let us see an example −
A student can work on more than one project. Student and Project are entities here. An individual student working on 2 projects at a time would be considered as One-to-Many relationship in DBMS as shown below:
Many to One Relationship
Many-to-One relationship in DBMS is a relationship between more than one instances of an entity with one instance of another entity.
The relation can be stated as −
A project can have more than one student working on it. A team of five students in a college in assigned a project that they need to complete in let us say one month. This states a relationship between two entities Student and Project.
- One-to-Many Unary Relationship in DBMS
- One-to-Many Relationship Model
- Many-to-Many Relationship in DBMS
- One-to-One Relationship in DBMS
- Many-to-Many Relationship Model
- Managing Many-to-Many relationship
- One-to-One Unary Relationship in DBMS
- One-to-One Relationship Model
- How to update many documents with one query in MongoDB?
- Python Pandas – Merge DataFrame with one-to-many relation
- Python Pandas – Merge DataFrame with many-to-one relation
- Appending an entry in one to many embedded documents with MongoDB
- SELECT * WHERE var == [one of many alternatives] in MySQL?
- How many Python classes should I put in one file?
- How many destructors can we have in one class in C#?