Benefits of Data Modeling

Regardless of the 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 automated tools can use to generate RDBMS-specific information. This way, you can use a single diagram to generate DB2 table schemas, and 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.