## Epoch

id | name | description
--- | --- | ---
1 | Ancient Greece | A civilization known for its contributions to philosophy and arts.
2 | Renaissance Europe | A period of great artistic and intellectual achievement.
3 | Victorian Era | Characterized by rapid industrialization and social change.
4 | 20th Century America | A time of significant cultural shifts and technological advancements.
5 | Modern Times | The current era marked by global interconnectedness and digital revolution.

## Society

id | name | culture
--- | --- | ---
1 | Athenian | Known for democracy, philosophy, and literature.
2 | Florentine | Home to the Renaissance and a center for art and learning.
3 | Elizabethan-Jacobean England | Known for the flourishing of significant developments in literature and the arts.
4 | American | Diverse and multicultural with strong individualism.
5 | Global Digital | Connected through technology and social media.

## Author

id | first_name | last_name
--- | --- | ---
1 | William | Shakespeare
2 | George | Orwell
3 | Jane | Austen
4 | Fyodor | Dostoevsky
5 | Ernest | Hemingway

## Genre

id | genre_type
--- | ---
1 | Tragedy
2 | Comedy
3 | Mystery
4 | Romance
5 | Science Fiction

## Play

id | title | summary | year_of_creation | epoch_id | society_id | author_id | genre_id
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Epoch.id) | (→ Society.id) | (→ Author.id) | (→ Genre.id)
1 | Hamlet | Prince of Denmark seeks revenge on his uncle. | 1603 | 2 | 3 | 1 | 1
2 | 1984 | Set in a dystopian future where totalitarianism is rampant. | 1949 | 4 | 4 | 2 | 3
3 | Pride and Prejudice | Follows Elizabeth Bennet as she navigates love and marriage. | 1813 | 3 | 3 | 3 | 4
4 | Crime and Punishment | A psychological thriller about a student who commits murder. | 1866 | 4 | 4 | 4 | 5
5 | Brave New World | Explores a utopian society built on genetic engineering and conditioning. | 1932 | 4 | 4 | 5 | 6