The article presents specific cases appearing in the design of manufacturing databases. In particular, a decomposition of entity model to the physical data model is presented. Understanding of significant differences between them makes it possible to build such structures of industrial databases that include special cases which occur in them. Different strategies for the transition from hierarchical entities model to targeted database tables are described. Additionally, an overview of problems associated with unary entities is outlined in this document.

The article presents specific cases appearing in the design of manufacturing databases. In particular, a decomposition of entity model to the physical data model is presented. Understanding of significant differences between them makes it possible to build such structures of industrial databases that include special cases which occur in them. Different strategies for the transition from hierarchical entities model to targeted database tables are described. Additionally, an overview of problems associated with unary entities is outlined in this document.