| AuthorId | Name | BirthDate | Country |
|---|---|---|---|
| 1 | John Doe | 1980-01-01 | USA |
| 2 | Jane Smith | 2000-06-15 | UK |
| 3 | Emily Johnson | 1975-02-22 | Canada |
| 4 | Michael Brown | 1990-10-28 | Australia |
| 5 | David Wilson | 1985-11-14 | New Zealand |
| 6 | Alexander White | 1992-04-03 | Germany |
| SubjectId | Name | Description |
|---|---|---|
| 1 | Mathematics | The study of numbers, quantities, shapes and spaces. |
| 2 | History | The study of past events and their causes and effects. |
| 3 | Biology | The study of living organisms and life processes. |
| 4 | Physics | The study of matter and energy, and how they interact with one another. |
| 5 | Philosophy | The study of fundamental questions about existence, knowledge, values, reason, mind and language. |
| BookId | Title | Literature | Rating | AuthorId | SubjectId |
|---|---|---|---|---|---|
| (→ Authors.AuthorId) | (→ Subjects.SubjectId) | ||||
| 1 | Math Mysteries | Fiction Book | 3.5 | 1 | 1 |
| 2 | A History of Mankind | Non-fiction Book | 4.0 | 2 | 2 |
| 3 | Life Forms | Fiction Book | 2.5 | 3 | 3 |
| 4 | Quantum Mechanics | Non-fiction Book | 3.5 | 4 | 4 |
| 5 | Ethical Questions | Fiction Book | 4.0 | 5 | 5 |
| 6 | Time Travel Theory | Non-fiction Book | 2.5 | 6 | 6 |
| ReviewId | Rating | Comment | BookId |
|---|---|---|---|
| (→ Books.BookId) | |||
| 1 | 3.5 | Great story! | 1 |
| 2 | 4.0 | Very informative. | 2 |
| 3 | 2.5 | Not what I expected... | 3 |
| 4 | 3.5 | Interesting read. | 4 |
| 5 | 4.0 | I learned a lot. | 5 |
| 6 | 2.5 | Could have been better. | 6 |