The Entity-Relationship (ER) model is one of the most popular methodologies for designing relational databases. Several commercial products have been developed to support drawing ER-diagrams in a graphical fashion. Their architectures and implementation details, however, are not available in public. Inspired by these products and recent developments in XML technology and semantic drawing framework Drawlet, we have developed an educational prototype ERDraw that supports drawing ER-diagrams visually and translating them to relational database schemas automatically. In this paper, we describe the architecture of ERDraw and its implementation details to illustrate how such a tool can be developed.
展开▼
