## Authors

AuthorID | FirstName | LastName | BirthDate | Nationality
--- | --- | --- | --- | ---
1 | John | Doe | 1960-01-01 | American
2 | Jane | Smith | 1987-03-22 | British

## Genres

GenreID | Name
--- | ---
1 | Biographies & Memoirs
2 | Fiction & Literature

## Publishers

PublisherID | Name | Address | YearEstablished
--- | --- | --- | ---
1 | AbeBooks | Abingdon Road, Abingdon, Oxfordshire OX14 3LY, UK | 1998
2 | Amazon Publishing | 41800 West 10 Mile Rd., Ada, MI 49355 | 2009

## Books

BookID | Title | Narrative_Form | Epoch | PageCount | PublicationYear | AuthorID | GenreID
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Authors.AuthorID) | (→ Genres.GenreID)
1 | My Life Story | Autobiography | 20th Century | 300 | 2000 | 1 | 1
2 | The Other Side of the World | Autobiography | 21st Century | 280 | 2018 | 2 | 2
3 | World War II History | Historical Account | 20th Century | 350 | 2010 | 3 | 3
4 | Modern American Society | Historical Account | 21st Century | 400 | 2012 | 4 | 4

## Published_Works

WorkID | BookID | PublisherID | ReleaseDate | SalesAmount
--- | --- | --- | --- | ---
| (→ Books.BookID) | (→ Publishers.PublisherID) |  |
1 | 1 | 1 | 2000-01-01 | 1000
2 | 2 | 2 | 2018-06-01 | 1500
3 | 3 | 1 | 2010-01-01 | 2000
4 | 4 | 2 | 2012-06-01 | 2500