1.6. A practical example

To help understand Mergeant usage, a simple example will be used throughout this documentation. This example comes from the 'examples' directory of the sources distribution of Mergeant.

It is the database used for managing the sales of a commercial company: several salesmen have each in charge one or more customers who can make orders which are composed of products stored in several warehouses.

The tables that have been created are:

To help understand the database structure, the figure below is a screenshot of the relations for all the tables'fields and sequences defined in the database:

Figure 1-2. Diagram to summarize the relations of the example database