Erwin is used to establish an entity-relation (E-R) model, which is an excellent CASE tool for relational database application development. Erwin can easily construct entities and contacts, express various constraints between entities, and create corresponding stored procedures, packages, triggers, roles, etc. according to templates, and write corresponding PB extended properties, such as editing styles, display style. , Validity verification rules, etc.
Erwin can achieve the conversion of the established ER model to the physical design of the database, you can automatically generate the library structure on a variety of database servers (such as Oracle, SQL Server, Watcom, etc.), improve the development efficiency of the database.
Erwin can carry out reverse engineering, automatically generate documents, support synchronization with database, support team development, and more than 20 kinds of databases supported. Erwin Database Design Tools can be used to generate application databases such as client / servers, web, intranet, and data warehouses.
Erwin is mainly used to establish a conceptual model and physical model of the database. It describes the properties of entities, contacts and entities with graphical ways. Erwin supports the IDEF1x method. Automatically generate, change, and analyze the IDEF1X model by using Erwin modeling tools, not only get excellent business functions and data demand models, but also enable transformation from the IDEF1x model to data physical design.
Erwin Tool Drawn Erwin Model Box Map is mainly composed of three component blocks: entity, attributes, and relationships, exactly three main components of the IDEF1X model. You can view the block diagram as a graphical language that expresss the business statement. The subject area (Subject Area) where the ERWIN model block diagram corresponds to the IDEF1x view, which focuses on a certain plan of the entire data model or an entity in an entity within the enterprise. A model of an IDEF1X includes one or more views, and the main Subject Areas in Erwin combines the entire range of data modeling, that is, the entire range of the IDEF1X model.
The model drawn by Erwin tool corresponds to both logical models and physical models. In the logical model, the IDEF1x toolbox can easily build and draw the properties of entity contacts and entities with graphical places. In the physical model, Erwin can define the corresponding table, column, and can automatically convert to the appropriate type for various database management systems.
Note: Erwin details and download, please visit my personal technical website: Beyond - Database program http://surpass.swpi.edu.cn (less domestic website-based website)
