## NarrativeForms

id | Narrative_Form
--- | ---
1 | Autobiography
2 | Historical Account

## Epochs

id | Epoch
--- | ---
1 | 20th Century
2 | 19th Century

## Authors

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

## Books

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

## BookAuthors

book_id | author_id
--- | ---
(→ Books.id) | (→ Authors.id)
1 | 1
2 | 2
3 | 3
4 | 3
5 | 2
6 | 1

## Narratives

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