## Novels

ID | Title | Author | Year | Genre | CharacterID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Characters.ID)
1 | The Great Gatsby | F. Scott Fitzgerald | 1925 | Classic Fiction | 1
2 | To Kill a Mockingbird | Harper Lee | 1960 | Coming of Age | 2
3 | Pride and Prejudice | Jane Austen | 1813 | Romance | 3
4 | Harry Potter and the Sorcerer's Stone | J.K. Rowling | 1997 | Adventure Fantasy | 4
5 | Moby Dick | Herman Melville | 1851 | Adventure Fiction | 5
6 | One Hundred Years of Solitude | Gabriel Garcia Marquez | 1967 | Magical Realism | 6

## ShortStories

ID | Title | Author | PublicationDate | Genre | CharacterID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Characters.ID)
1 | A Rose for Emily | William Faulkner | 1930-05-01 | Mystery | 1
2 | The Lottery | Shirley Jackson | 1948-06-26 | Dystopian Fiction | 2
3 | The Tell-Tale Heart | Edgar Allan Poe | 1843-10-01 | Horror | 3
4 | The Necklace | Guy de Maupassant | 1884-01-01 | Realistic Fiction | 4
5 | The Gift of the Magi | O. Henry | 1906-01-15 | Sentimental Romance | 5

## Authors

ID | Name | BirthYear | DeathYear
--- | --- | --- | ---
1 | F. Scott Fitzgerald | 1896 | 1940
2 | Harper Lee | 1926 | 2016
3 | Jane Austen | 1775 | 1817
4 | J.K. Rowling | 1965 | None
5 | Herman Melville | 1819 | 1891
6 | Gabriel Garcia Marquez | 1927 | 2014

## Characters

ID | Name | Age | Occupation
--- | --- | --- | ---
1 | John Smith | 30 | Engineer
2 | Tom Robinson | 35 | Laborer
3 | Elizabeth Bennet | 20 | Gentlewoman
4 | Hermione Granger | 11 | Student
5 | Ishmael | 22 | Sailor

## Schools

SchoolId | SchoolName | Location | NumberOfStudents
--- | --- | --- | ---
1 | Central High School | New York City | 1000
2 | Westside Elementary | Los Angeles | 500
3 | Eastern College | Chicago | 2000
4 | Mountain View Academy | Denver | 800
5 | South Coast Middle School | San Diego | 700

## Students

StudentId | FirstName | LastName | DateOfBirth | GradeLevel | SchoolId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Schools.SchoolId)
1 | Mark | Smith | 1998-09-01 | 10 | 1
2 | Emily | Johnson | 2000-05-15 | 8 | 2
3 | Alex | Martinez | 2002-11-22 | 6 | 3
4 | Zara | Patel | 2004-08-10 | 5 | 4
5 | Noah | Wilson | 2006-03-28 | 4 | 5