A good algorithm to design such a hierarchical database consists of two steps, first, to describe real world in E-Rmodel and then, convert it to the model supported by the DBMS.
The logic framework structured design is consisted of theory analysis of function dependency, relation normalization, transformation from E-Rmodel to relation model and data model normalization.
逻辑结构设计包括函数依赖和关系规范化的理论分析、E - R模型向关系模型的转换和数据模式规范化。
3
According to the deficiency of traditional E-Rmodel in large database designing, the paper puts forward a design idea of object-oriented database based on UML.