2. The examples.fdb Database

Before we explore the process of creating applications in various programming languages, we will walk through the creation and preparation of the database that is used as the back-end to all of the sample projects.

The applications work with a database based on the model illustrated in this diagram:

fbdevgd30 db 001 en

Figure 1. Model of the examples.fdb database

Disclaimer

This chapter does not attempt to provide a tutorial about database design or SQL syntax. The model is made as simple as possible to avoid cluttering the application development techniques with topics about database modeling and development. We hope some readers might be enlightened by our approach to maintaining interrelated data using stored procedures. The scripts are all here for you to refer to as you work your way through the projects.

The requirements for your real-life projects are undoubtedly different from and much more complicated than those for our example projects.