| AuthorID | FirstName | LastName | BirthDate | Nationality |
|---|---|---|---|---|
| 1 | John | Doe | 1960-01-01 | American |
| 2 | Jane | Smith | 1987-03-22 | British |
| GenreID | Name |
|---|---|
| 1 | Biographies & Memoirs |
| 2 | Fiction & Literature |
| 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 |
| 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 |
| 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 |