Data modeling in EA

[Shreyansh]

Hi,

I am using EA for designing data base tables. Using EA it is possible to generate DDL scripts of data modal.
I want that some of my tables contain default rows as a master entry. Is it is possible using EA.

Regards,
Shreyansh Doshi

[operaman]

Hi Shreyansh,

I'm not certain if I understand your question about 'default rows as a master entry' for tables, however, you can certainly generate a DDL from a Data Model.

Ideally, you will model your classes in a Class Model first (these will eventually become tables in your Data Model package) and then run the 'Transform Current Package' functionality from the Class Model - targeting your Data Model package as the destination for the generated Data Model (typically the generated data model is put in a sub-package called DDL).  

This transformation is commonly called PIM to PSM transformation (Platform Independent Model to Platform Specific Model). Since you are generating a PSM, you should first specify your target DBMS.

Once your Data Model is transformed from your Class model you can right-click on the DDL package (under Data Model package) and select 'Code Engineering -> Generate DDl...' That will generate the DDL statements to do the CREATE / ALTER TABLES and keys and indexes etc, that you can execute in your target DBMS.

You will need to have 'Generate source code and DDL' permission in your version of EA in order to do the DDL generation.

HTH.