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 |