Structure of this user guide

The Objecteering SQL Designer user guide is structured as follows:

· The "Using SQL Designer" chapter: This chapter provides information on how to configure and use SQL Designer.

· The "Quick tour" chapter: This chapter is based on a demonstration project that will help you discover, step by step, the creation of tables in a database.

· The "Generation principles" chapter: This chapter describes the generation principles for the transformation of the logical model in Objecteering into the relational model, and details available mapping rules and options. For each unit of the object structure model (class, attribute, generalization link, association), different possible mappings are presented. Integrity checks that can be deduced from the model are presented at the end of the chapter.

· The "User interface" chapter: This chapter offers a man/machine interface approach to Objecteering SQL Designer. Starting with a package designed according to the principles developed in the previous chapter, the interface allows:

· generation of the physical model from the logical model

· interactive generation of the database diagram

· visualization of the SQL produced and the execution of this SQL using the target RDBMS

· The "Annotating the model" chapter: This chapter contains, for each model unit, all the tagged values common to all RDBMS handled by Objecteering generation.

· Annexes: For each RDBMS handled by the generator, an annex presents the required environment, data mapping, special generation cases and specific tagged values.