Table 1.3. structure of the "literature" table
| Fieldname | Type | Description |
|---|---|---|
| literature_id | auto increment | unique identification number for each book or poem |
| author | integer | the author id |
| title | memo | the title of the book |
Table 1.4. the data in the "literature" table
| literature_id | author | title |
|---|---|---|
| 1 | 1 | Götz von Berlichingen |
| 2 | 1 | Faust |
| 3 | 1 | Iphigenie auf Tauris |
| 4 | 2 | Don Carlos |
| 5 | 2 | Die Räuber |
| 6 | 2 | Wallenstein |
| 7 | 3 | Nathan der Weise |
| 8 | 3 | Minna von Barnhelm |