Construction and Test › Generating the Database › Database Generation › Basic Data Model Transformation

Basic Data Model Transformation

During the Transformation process, there is a set of basic rules applied to create the Data Structure List:

• Entity Types become Tables
• Attributes become Columns within the Tables
• Identifiers become Unique Indexes
• Relationships become Foreign Key Columns in one of the Tables involved in the relationship or the other with Indexes and RI (Referential Integrity) Constraints created on them

Additionally, the Transformation process calculates tablespaces and indexspaces to create the Data Store List.

Once the Transformation process has completed, you would then make any implementation-specific changes required to these two diagrams prior to generating the DDL and DML.