Novels

IDTitleAuthorYearGenreCharacterID
(→ Characters.ID)
1The Great GatsbyF. Scott Fitzgerald1925Classic Fiction1
2To Kill a MockingbirdHarper Lee1960Coming of Age2
3Pride and PrejudiceJane Austen1813Romance3
4Harry Potter and the Sorcerer's StoneJ.K. Rowling1997Adventure Fantasy4
5Moby DickHerman Melville1851Adventure Fiction5
6One Hundred Years of SolitudeGabriel Garcia Marquez1967Magical Realism6

ShortStories

IDTitleAuthorPublicationDateGenreCharacterID
(→ Characters.ID)
1A Rose for EmilyWilliam Faulkner1930-05-01Mystery1
2The LotteryShirley Jackson1948-06-26Dystopian Fiction2
3The Tell-Tale HeartEdgar Allan Poe1843-10-01Horror3
4The NecklaceGuy de Maupassant1884-01-01Realistic Fiction4
5The Gift of the MagiO. Henry1906-01-15Sentimental Romance5

Authors

IDNameBirthYearDeathYear
1F. Scott Fitzgerald18961940
2Harper Lee19262016
3Jane Austen17751817
4J.K. Rowling1965None
5Herman Melville18191891
6Gabriel Garcia Marquez19272014

Characters

IDNameAgeOccupation
1John Smith30Engineer
2Tom Robinson35Laborer
3Elizabeth Bennet20Gentlewoman
4Hermione Granger11Student
5Ishmael22Sailor

Schools

SchoolIdSchoolNameLocationNumberOfStudents
1Central High SchoolNew York City1000
2Westside ElementaryLos Angeles500
3Eastern CollegeChicago2000
4Mountain View AcademyDenver800
5South Coast Middle SchoolSan Diego700

Students

StudentIdFirstNameLastNameDateOfBirthGradeLevelSchoolId
(→ Schools.SchoolId)
1MarkSmith1998-09-01101
2EmilyJohnson2000-05-1582
3AlexMartinez2002-11-2263
4ZaraPatel2004-08-1054
5NoahWilson2006-03-2845