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 |