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 |
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 |
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 |
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 |
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 |
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 |