| id | Narrative_Form |
|---|---|
| 1 | Autobiography |
| 2 | Historical Account |
| id | Epoch |
|---|---|
| 1 | 20th Century |
| 2 | 19th Century |
| id | Name | Birthdate | Deathdate |
|---|---|---|---|
| 1 | Author A | 1874-03-16 | None |
| 2 | Author B | 1925-08-15 | 1989-05-25 |
| 3 | Author C | 1930-12-10 | 2005-03-07 |
| id | Title | Genre | PublicationYear |
|---|---|---|---|
| 1 | Book X | Fiction | 2000 |
| 2 | Book Y | Nonfiction | 1995 |
| 3 | Book Z | Poetry | 2002 |
| 4 | Book W | Biography | 2010 |
| 5 | Book V | Self Help | 2009 |
| book_id | author_id |
|---|---|
| (→ Books.id) | (→ Authors.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 3 |
| 5 | 2 |
| 6 | 1 |
| id | narrative_form_id | epoch_id | title | publication_year |
|---|---|---|---|---|
| (→ NarrativeForms.id) | (→ Epochs.id) | (→ Books.Title) | ||
| 1 | 1 | 1 | My Life Story | 2000 |
| 2 | 1 | 2 | More of My Life | 2005 |
| 3 | 2 | 1 | Events That Shaped The World | 1997 |
| 4 | 2 | 2 | Another Historical Event | 2003 |
| 5 | 3 | 3 | Random Thoughts | 2008 |
| 6 | 4 | 4 | How I Overcame Fear | 2012 |
| 7 | 5 | 5 | Life Lessons Learned | 2011 |