Introduction › Benefits of Data Modeling

Benefits of Data Modeling

Regardless of the type of DBMS you use or the types of data models you want to develop, modeling your database in CA ERwin DM has many benefits:

• Enables usage by database and application development staff to define system requirements and to communicate among themselves and with end-users.
• Provides a clear picture of referential integrity constraints. Maintaining referential integrity is essential in the relational model where relationships are encoded implicitly.
• Provides a logical RDBMS-independent picture of your database that can be used by automated tools to generate RDBMS-specific information. This way, you can use a single diagram to generate DB2 table schemas, as well as schemas for other relational DBMSs.
• Lets you produce a diagram summarizing the results of your data modeling efforts and generate a database schema from that model.