Data Modeling & SQL
MacA&D and WinA&D support a rich environment for data modeling and SQL code generation. In addition to creating logical and physical data models, diagram presentations can be customized and non-visual SQL elements can be defined. SQL can be generated for RDBMS products including Oracle, DB2, SQL Server, Sybase, Informix and InterBase.|
An Entity Relation Diagram (ERD) shows the static structure of information in a database. Often each entity in the model represents a table in the database and each entity attribute represents a table column. Other information shown in the model includes primary and foreign keys and important relationships between entities.