Developing a new application that includes a database

Context

A large-scale application is being developed. This application uses a database whose architecture plays a strategic role in the development that is underway.

Solution

Model your database at conceptual or logical level using the modeling services provided by SQL Designer.
Generate the SQL database script from the table model using the " Generate SQL Script" command.
Transform the table model into a data model using the " Transform Table Model into Data Model" command.
Generate the persistent model’s Java classes and the associated Hibernate mapping files using the " Hibernate & Java Generation" command.

You have just produced your application’s Java data model, your database’s SQL script and the Hibernate mapping files used to ensure object / relational mapping between the Java objects and the database.