| AuthorID | Name |
|---|---|
| 1 | Emily Dickinson |
| 2 | Robert Frost |
| 3 | Maya Angelou |
| 4 | George Orwell |
| 5 | Jane Austen |
| GenreID | Name |
|---|---|
| 1 | Essay |
| 2 | Poetry |
| 3 | Novel |
| 4 | Short Story |
| 5 | Biography |
| BookID | Title | PublishedYear | AuthorID | GenreID |
|---|---|---|---|---|
| (→ Authors.AuthorID) | (→ Genres.GenreID) | |||
| 1 | Poems | 1890 | 1 | 1 |
| 2 | The Road Not Taken | 1916 | 2 | 2 |
| 3 | I Know Why The Caged Bird Sings | 1969 | 3 | 3 |
| 4 | Animal Farm | 1945 | 4 | 4 |
| 5 | Pride and Prejudice | 1797 | 5 | 5 |
| WorkID | BookID | TypeOfWork |
|---|---|---|
| (→ Books.BookID) | ||
| 1 | 1 | Essay |
| 2 | 1 | Poetry |
| 3 | 2 | Essay |
| 4 | 2 | Poetry |
| 5 | 3 | Novel |
| 6 | 4 | Short Story |
| 7 | 5 | Biography |