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 |