Firebird Documentation IndexFirebird 3.0 Developer's Guide → The examples.fdb Database
Firebird Home Firebird Home Prev: AcknowledgmentsFirebird Documentation IndexUp: Firebird 3.0 Developer's GuideNext: Database Creation Script

Chapter 2: The examples.fdb Database

Table of Contents

Database Creation Script
Database Aliases
Creating the Database Objects
Domains
Primary Tables
Secondary Tables
Stored Procedures
Roles and Privileges for Users
Saving and Running the Script
Loading Test Data

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:

Figure 2.1. Model of the examples.fdb database

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.

Prev: AcknowledgmentsFirebird Documentation IndexUp: Firebird 3.0 Developer's GuideNext: Database Creation Script
Firebird Documentation IndexFirebird 3.0 Developer's Guide → The examples.fdb Database