How to model a recursive relationship in a relational model?

257 Views Asked by At

Is it possible to model a recursive relationship (such as seen in the photo) using the relational model? I find it hard to believe that the relation user would receive a foreign key from itself to signify the 1:n relationship it has with itself in the relationship "is_referred_by". An entity in an EER Diagram with a recursive relationship

0

There are 0 best solutions below