The reverse engineering creates an elementary CaseTalk model through a simple ADO connection. The tables, columns, key information, and relations are all created as facts and are made to be verbalized. This way, the database model can be validated as a conceptual model following the regular rules.

The following diagram is a partial visualization of a small reverse-engineered database model:

Department

Generating an ERD from this conceptual model will look like this:

ERD after Reverse Engineering

 


One connected to a database, you can view and select available tables and columns. Possible issues that may lead to a wrong conceptual model are made visible before the actual import is started. For instance, you may choose to rename tables or columns to provide unique fact names for the conceptual model.


 


Some advantages are:

 

  •     Validations can be made using standard FCO-IM ruleset.
  •     Through Expression generation the end-user is now able to validate the implemented database
  •     Conceptuality checking is now possible and the model can be extended with little extra effort.

The project files can be found on Github.

CaseTalk

We make IT better. Together!