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.

Click at the left for a bigger image or visit the Data Modeling Introduction to learn more about data modeling, SQL generation and reengineering. Click a box below for a detailed product description.

MacTranslator for Macintosh and WinTranslator for Windows can process an SQL schema to extract the information required to generate a rich data model in MacA&D or WinA&D.