- 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 Unary Relationship in DBMS
102 Lectures 7.5 hours
152 Lectures 16 hours
A One-to-Many Unary Relationship is the association with the same entity between the same instances represented by different role groups.
Consider the relationship between Managers and Employees.
The two different Roles in this relationship are- Managers and Employees. Only few Employees take the role of Managers within an organization while everyone working for an organization is an Employee.
One Manager manages multiple Employees and each Manager is also an Employee.
Each instance of one role group must participate in the relationship while instance of other role group can optionally participate in the relationship.
The Role of Manager satisfies the optional participation as there are Employees as managers and non-managers. The Employee role group violates the role uniqueness because at least one employee at the top level of management doesn’t have a manager.
The One-to-Many Optional-Optional is valid in this case as Manager Role is optional for the Employees and a senior top most management Employee is not managed by other instances in the entity.
- One-to-One Unary Relationship in DBMS
- One-to-Many or Many-to-One Relationship in DBMS
- Many-to-Many Relationship in DBMS
- One-to-One Relationship in DBMS
- One-to-Many Relationship Model
- Unary or Recursive Relationship
- Many-to-Many Relationship Model
- Managing Many-to-Many relationship
- One-to-One Relationship Model
- Explain the unary operations of algebra relations in DBMS?
- What is an Entity relationship model in DBMS?
- What is the degree of relationship set in DBMS?
- How to update many documents with one query in MongoDB?
- Unary operator in C++
- Unary operators in C++