Chapter 1. The example database "exampledb"
Prev The KNODA user's tutorial Next

Chapter 1. The example database "exampledb"

Table of Contents

The "authors" table
The "literature" table

The following chapters describe the example database that will be the basis for all hk_classes tutorials and manuals.

The database is a literature database; it should store the author's names and the titles of their literary works. The data I have actually used in this example database are the names of three famous 18th century German authors and some of their plays.

database name: exampledb

The database contains two tables

which are in a one-to-many relationship, which means that a author could have written one or more texts.

The "authors" table

Table 1.1. structure of the "authors" table

FieldnameTypeDescription
author_idauto incrementunique identification number for each author
nametext 255the name of the author
birthyeartext 6year of his birth
deathyeartext 6year of his death

Table 1.2. the data in the "authors" table

author_idnamebirthyeardeathyear
1Goethe, Johann Wolfgang von17491832
2Schiller, Friedrich von17591805
3Lessing, Gotthold Ephraim17291781
Prev Up Next
The KNODA user's tutorial Home The "literature" table