Programming
Aptitude
Syllabus
Interview Preparation
Interview Exp.
Off Campus
0Unary Relationship in DBMS
Unary Relationship in DBMS
On this page, we will learn about Unary Relationship in DBMS.
- A relationship represents the association between two are more entities
- The relationship also shows the different entity sets that are participating in a relationship, these relationships very much useful analyzing the design process of the system
unary relationship exists. 
Unary relationship
When there is only one entity set participating in a relationship then such type of relationship is called unary relationship
Example of unary relationship
For example, a person has only one passport and only one passport is given to only one person and hence unary relationship is observed
Prime Course Trailer
Related Banners
Get PrepInsta Prime & get Access to all 200+ courses offered by PrepInsta in One Subscription
Get over 200+ course One Subscription
Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others
Login/Signup to comment
The example for unary relationship is wrong it seems. You have provided two entities in the example(Citizen and Passport) but in the definition itself you provided “only one entity”.i think unary relationship is same as recursive(i.e relationship between same entity). Correct me if I am wrong.
Sid, read the example also, from there you’ll understand that unary relationship is the phenomena where the entities are attached in a single relationship like each particular person has a distinctive mobile number, no two person can have the same number, and the same number cannot be alloted to two different persons, I hope this will help you out