Recursive relationship

Recursive relationship: An entity can be related to itself

 

The above ER diagram comprises of products consisting of a hierarchy of assemblies. One assembly contains other assemblies. One assembly is contained in other assemblies.