4xzcf3Zh

1CREATE DATABASE IF NOT EXISTS lab9;
2
3GRANT SELECT ON *.* TO 'lab9'@'%';
4
5USE lab9;
6
7/*--------- book data -----------*/
8DROP TABLE IF EXISTS users;
9
10CREATE TABLE users (
11    id INTEGER(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
12    username VARCHAR(256) NOT NULL,
13    password VARCHAR(256) NOT NULL
14);
15
16INSERT INTO users(username, password) VALUES 
17('admin', 'Pass@1234'),
18('alice', '1234'),
19('bob', '1234');
20
21/*--------- book data -----------*/
22DROP TABLE IF EXISTS books;
23
24CREATE TABLE books (
25    id INTEGER(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
26    title VARCHAR(256) NOT NULL,
27    author VARCHAR(256) NOT NULL
28);
29
30INSERT INTO books(title, author) VALUES
31("The Hunger Games (The Hunger Games, #1)", "Suzanne Collins"),
32("Harry Potter and the Order of the Phoenix (Harry Potter, #5)", "J.K.  Rowling"),
33("To Kill a Mockingbird", "Harper Lee"),
34("Pride and Prejudice", "Jane Austen"),
35("Twilight (Twilight, #1)", "Stephenie Meyer"),
36("The Chronicles of Narnia (Chronicles of Narnia, #1-7)", "C.S. Lewis"),
37("The Book Thief", "Markus Zusak"),
38("Animal Farm", "George Orwell"),
39("Gone with the Wind", "Margaret Mitchell"),
40("The Hitchhiker's Guide to the Galaxy (Hitchhiker's Guide to the Galaxy, #1)", "Douglas Adams"),
41("The Giving Tree", "Shel Silverstein"),
42("The Fault in Our Stars", "John Green"),
43("J.R.R. Tolkien 4-Book Boxed Set: The Hobbit and The Lord of the Rings", "J.R.R. Tolkien"),
44("Wuthering Heights", "Emily Brontë"),
45("The Da Vinci Code (Robert Langdon, #2)", "Dan Brown"),
46("Memoirs of a Geisha", "Arthur Golden"),
47("Alice's Adventures in Wonderland & Through the Looking-Glass", "Lewis Carroll"),
48("Les Misérables", "Victor Hugo"),
49("Divergent (Divergent, #1)", "Veronica Roth"),
50("Romeo and Juliet", "William Shakespeare"),
51("The Picture of Dorian Gray", "Oscar Wilde"),
52("Lord of the Flies", "William Golding"),
53("Jane Eyre", "Charlotte Brontë"),
54("The Alchemist", "Paulo Coelho"),
55("Ender's Game (Ender's Saga, #1)", "Orson Scott Card"),
56("Crime and Punishment", "Fyodor Dostoyevsky"),
57("The Time Traveler's Wife", "Audrey Niffenegger"),
58("City of Bones (The Mortal Instruments, #1)", "Cassandra Clare"),
59("Charlotte's Web", "E.B. White"),
60("The Help", "Kathryn Stockett"),
61("The Perks of Being A Wallflower", "Stephen Chbosky"),
62("Anne of Green Gables (Anne of Green Gables, #1)", "L.M. Montgomery"),
63("Of Mice and Men", "John Steinbeck"),
64("The Great Gatsby", "F. Scott Fitzgerald"),
65("Dracula", "Bram Stoker"),
66("Brave New World", "Aldous Huxley"),
67("One Hundred Years of Solitude", "Gabriel García Márquez"),
68("The Princess Bride", "William Goldman"),
69("A Wrinkle in Time (A Wrinkle in Time Quintet, #1)", "Madeleine L'Engle"),
70("The Secret Garden", "Frances Hodgson Burnett"),
71("A Thousand Splendid Suns", "Khaled Hosseini"),
72("The Catcher in the Rye", "J.D. Salinger"),
73("The Little Prince", "Antoine de Saint-Exupéry (Author/Illustrator)"),
74("The Adventures of Huckleberry Finn", "Mark Twain"),
75("The Lovely Bones", "Alice Sebold"),
76("Where the Wild Things Are", "Maurice Sendak"),
77("Green Eggs and Ham", "Dr. Seuss"),
78("Fahrenheit 451", "Ray Bradbury"),
79("Water for Elephants", "Sara Gruen"),
80("Life of Pi", "Yann Martel"),
81("A Tale of Two Cities", "Charles Dickens"),
82("The Odyssey", "Homer"),
83("A Game of Thrones (A Song of Ice and Fire, #1)", "George R.R. Martin"),
84("The Lightning Thief (Percy Jackson and the Olympians, #1)", "Rick Riordan"),
85("The Outsiders", "S.E. Hinton"),
86("Lolita", "Vladimir Nabokov"),
87("Slaughterhouse-Five", "Kurt Vonnegut"),
88("Catch-22", "Joseph Heller"),
89("Dune", "Frank Herbert"),
90("The Pillars of the Earth (The Pillars of the Earth, #1)", "Ken Follett"),
91("Frankenstein", "Mary Shelley"),
92("The Stand", "Stephen King"),
93("Watership Down (Watership Down #1)", "Richard Adams"),
94("The Kite Runner", "Khaled Hosseini"),
95("The Adventures of Sherlock Holmes (Sherlock Holmes, #3)", "Arthur Conan Doyle"),
96("My Sister's Keeper", "Jodi Picoult"),
97("The Giver (The Giver, #1)", "Lois Lowry"),
98("One Flew Over the Cuckoo's Nest", "Ken Kesey"),
99("The Bell Jar", "Sylvia Plath"),
100("The Handmaid's Tale", "Margaret Atwood"),
101("Outlander (Outlander #1)", "Diana Gabaldon"),
102("Anna Karenina", "Leo Tolstoy"),
103("A Tree Grows in Brooklyn", "Betty  Smith"),
104("Rebecca", "Daphne du Maurier"),
105("Harry Potter and the Sorcerer's Stone (Harry Potter, #1)", "J.K. Rowling"),
106("The Color Purple", "Alice Walker"),
107("The Girl with the Dragon Tattoo (Millennium, #1)", "Stieg Larsson"),
108("Angela's Ashes (Frank McCourt, #1)", "Frank McCourt"),
109("The Road", "Cormac McCarthy"),
110("A Clockwork Orange", "Anthony Burgess"),
111("Matilda", "Roald Dahl"),
112("Little Women (Little Women, #1)", "Louisa May Alcott"),
113("The Brothers Karamazov", "Fyodor Dostoyevsky"),
114("Vampire Academy (Vampire Academy, #1)", "Richelle Mead"),
115("The Poisonwood Bible", "Barbara Kingsolver"),
116("The Fellowship of the Ring (The Lord of the Rings, #1)", "J.R.R. Tolkien"),
117("Siddhartha", "Hermann Hesse"),
118("Atlas Shrugged", "Ayn Rand"),
119("Don Quixote", "Miguel de Cervantes Saavedra"),
120("Fahrenheit 451", "Ray Bradbury"),
121("The Golden Compass (His Dark Materials, #1)", "Philip Pullman"),
122("The Notebook (The Notebook, #1)", "Nicholas Sparks"),
123("The Old Man and the Sea", "Ernest Hemingway"),
124("Great Expectations", "Charles Dickens"),
125("A Prayer for Owen Meany", "John Irving"),
126("The Complete Stories and Poems", "Edgar Allan Poe"),
127("Moby-Dick; or, The Whale", "Herman Melville"),
128("Interview with the Vampire (The Vampire Chronicles, #1)", "Anne Rice"),
129("Winnie-the-Pooh (Winnie-the-Pooh, #1)", "A.A. Milne"),
130("The Red Tent", "Anita Diamant"),
131("The Secret Life of Bees", "Sue Monk Kidd"),
132("Harry Potter and the Deathly Hallows (Harry Potter, #7)", "J.K. Rowling"),
133("Clockwork Angel (The Infernal Devices, #1)", "Cassandra Clare"),
134("Middlesex", "Jeffrey Eugenides"),
135("Great Expectations", "Charles Dickens"),
136("The Adventures of Tom Sawyer", "Mark Twain"),
137("On the Road", "Jack Kerouac"),
138("The Stranger", "Albert Camus"),
139("Charlie and the Chocolate Factory (Charlie Bucket, #1)", "Roald Dahl"),
140("The Master and Margarita", "Mikhail Bulgakov"),
141("1984", "George Orwell"),
142("Eragon (The Inheritance Cycle, #1)", "Christopher Paolini"),
143("The Very Hungry Caterpillar", "Eric Carle"),
144("Tuesdays with Morrie", "Mitch Albom"),
145("The Shining (The Shining #1)", "Stephen King"),
146("And Then There Were None", "Agatha Christie"),
147("The Unbearable Lightness of Being", "Milan Kundera"),
148("The Shadow of the Wind (The Cemetery of Forgotten Books,  #1)", "Carlos Ruiz Zafón"),
149("The Curious Incident of the Dog in the Night-Time", "Mark Haddon"),
150("The Scarlet Letter", "Nathaniel Hawthorne"),
151("Flowers for Algernon", "Daniel Keyes"),
152("Looking for Alaska", "John Green"),
153("Hush, Hush (Hush, Hush, #1)", "Becca Fitzpatrick"),
154("The Metamorphosis", "Franz Kafka"),
155("The Name of the Rose", "Umberto Eco"),
156("The Five People You Meet in Heaven", "Mitch Albom"),
157("Harry Potter and the Prisoner of Azkaban (Harry Potter, #3)", "J.K.  Rowling"),
158("The Godfather", "Mario Puzo"),
159("The Name of the Wind (The Kingkiller Chronicle, #1)", "Patrick Rothfuss"),
160("Lonesome Dove", "Larry McMurtry"),
161("In Cold Blood", "Truman Capote"),
162("The Cat in the Hat", "Dr. Seuss"),
163("The Compleat Works of Wllm Shkspr", "Reduced Shakespeare Company"),
164("The Little House Collection (Little House, #1-9)", "Laura Ingalls Wilder"),
165("Fight Club", "Chuck Palahniuk"),
166("Watchmen", "Alan Moore"),
167("The Divine Comedy", "Dante Alighieri"),
168("Holes (Holes, #1)", "Louis Sachar"),
169("Shadow Kiss (Vampire Academy, #3)", "Richelle Mead"),
170("All Quiet on the Western Front", "Erich Maria Remarque"),
171("Peter Pan", "J.M. Barrie"),
172("American Gods (American Gods, #1)", "Neil Gaiman"),
173("Insurgent (Divergent, #2)", "Veronica Roth"),
174("A Walk to Remember", "Nicholas Sparks"),
175("Perfume: The Story of a Murderer", "Patrick Süskind"),
176("Harry Potter and the Goblet of Fire (Harry Potter, #4)", "J.K. Rowling"),
177("Love in the Time of Cholera", "Gabriel García Márquez"),
178("The Thorn Birds", "Colleen McCullough"),
179("The Last Olympian (Percy Jackson and the Olympians, #5)", "Rick Riordan"),
180("The Lion, the Witch, and the Wardrobe (Chronicles of Narnia, #1)", "C.S.  Lewis"),
181("It", "Stephen King"),
182("Their Eyes Were Watching God", "Zora Neale Hurston"),
183("Frostbite (Vampire Academy, #2)", "Richelle Mead"),
184("How the Grinch Stole Christmas!", "Dr. Seuss"),
185("Eat, Pray, Love", "Elizabeth Gilbert"),
186("Atonement", "Ian McEwan"),
187("The Ultimate Hitchhiker's Guide to the Galaxy (Hitchhiker's Guide to the),
188(Galaxy #1-5)", "Douglas Adams"),
189("Goodnight Moon", "Margaret Wise Brown"),
190("The Importance of Being Earnest", "Oscar Wilde"),
191("Harry Potter and the Half-Blood Prince (Harry Potter, #6)", "J.K. Rowling"),
192("The Wonderful Wizard of Oz (Oz, #1)", "L. Frank Baum"),
193("Blood Promise (Vampire Academy, #4)", "Richelle Mead"),
194("The Three Musketeers", "Alexandre Dumas"),
195("The Lorax", "Dr. Seuss"),
196("The Good Earth (House of Earth, #1)", "Pearl S. Buck"),
197("The Count of Monte Cristo", "Alexandre Dumas"),
198("Where the Red Fern Grows", "Wilson Rawls"),
199("Tess of the D'Urbervilles", "Thomas Hardy"),
200("A Midsummer Night's Dream", "William Shakespeare"),
201("The Mists of Avalon (Avalon, #1)", "Marion Zimmer Bradley"),
202("The Prophet", "Kahlil Gibran"),
203("Heart of Darkness", "Joseph Conrad"),
204("The Joy Luck Club", "Amy Tan"),
205("Jonathan Livingston Seagull", "Richard Bach"),
206("Good Omens: The Nice and Accurate Prophecies of Agnes Nutter, Witch", "Terry Pratchett"),
207("The Battle of the Labyrinth (Percy Jackson and the Olympians, #4)", "Rick Riordan"),
208("The Phantom Tollbooth", "Norton Juster"),
209("Madame Bovary", "Gustave Flaubert"),
210("Alice in Wonderland (Alice's Adventures in Wonderland, #1)", "Lewis Carroll"),
211("The Call of the Wild", "Jack London"),
212("Fifty Shades of Grey (Fifty Shades, #1)", "E.L. James"),
213("The Girl Who Played with Fire (Millennium, #2)", "Stieg Larsson"),
214("The Sea of Monsters (Percy Jackson and the Olympians, #2)", "Rick Riordan"),
215("Bridge to Terabithia", "Katherine Paterson"),
216("Oh, The Places You'll Go!", "Dr. Seuss"),
217("Oliver Twist", "Charles Dickens"),
218("The Canterbury Tales", "Geoffrey Chaucer"),
219("The Titan's Curse (Percy Jackson and the Olympians, #3)", "Rick Riordan"),
220("The Clan of the Cave Bear (Earth's Children, #1)", "Jean M. Auel"),
221("Ulysses", "James Joyce"),
222("The Hunger Games Trilogy Boxset (The Hunger Games, #1-3)", "Suzanne Collins"),
223("Harry Potter and the Chamber of Secrets (Harry Potter, #2)", "J.K.  Rowling"),
224("Clockwork Princess (The Infernal Devices, #3)", "Cassandra Clare"),
225("A Farewell to Arms", "Ernest Hemingway"),
226("The World According to Garp", "John Irving"),
227("The Maze Runner (Maze Runner, #1)", "James Dashner"),
228("Wicked: The Life and Times of the Wicked Witch of the West (The Wicked Years,),
229(#1)", "Gregory Maguire"),
230("Treasure Island", "Robert Louis Stevenson"),
231("The Neverending Story", "Michael Ende"),
232("The Other Boleyn Girl (The Plantagenet and Tudor Novels, #9)", "Philippa Gregory"),
233("David Copperfield", "Charles Dickens"),
234("Last Sacrifice (Vampire Academy, #6)", "Richelle Mead"),
235("Fallen (Fallen, #1)", "Lauren Kate"),
236("Thirteen Reasons Why", "Jay Asher"),
237("Extremely Loud and Incredibly Close", "Jonathan Safran Foer"),
238("Shōgun (Asian Saga, #1)", "James Clavell"),
239("A Storm of Swords (A Song of Ice and Fire, #3)", "George R.R. Martin"),
240("Schindler's List", "Thomas Keneally"),
241("His Dark Materials (His Dark Materials #1-3)", "Philip Pullman"),
242("Spirit Bound (Vampire Academy, #5)", "Richelle Mead"),
243("A Little Princess", "Frances Hodgson Burnett"),
244("The Sun Also Rises", "Ernest Hemingway"),
245("A Confederacy of Dunces", "John Kennedy Toole"),
246("The Secret Magdalene", "Ki Longfellow"),
247("Beloved (The Trilogy, #1)", "Toni Morrison"),
248("The Velveteen Rabbit", "Margery Williams Bianco"),
249("Shiver (The Wolves of Mercy Falls, #1)", "Maggie Stiefvater"),
250("The Crucible", "Arthur Miller"),
251("She's Come Undone", "Wally Lamb"),
252("Girl with a Pearl Earring", "Tracy Chevalier"),
253("Jurassic Park", "Michael Crichton"),
254("Cat's Cradle", "Kurt Vonnegut"),
255("The Silmarillion", "J.R.R. Tolkien"),
256("The Boy in the Striped Pajamas", "John Boyne"),
257("The Hobbit", "J.R.R. Tolkien"),
258("The Hiding Place: The Triumphant True Story of Corrie Ten Boom", "Corrie ten Boom"),
259("The Wind in the Willows", "Kenneth Grahame"),
260("Marley and Me: Life and Love With the World's Worst Dog", "John Grogan"),
261("A Light in the Attic", "Shel Silverstein"),
262("Uglies (Uglies, #1)", "Scott Westerfeld"),
263("The God of Small Things", "Arundhati Roy"),
264("Murder on the Orient Express (Hercule Poirot, #10)", "Agatha Christie"),
265("Clockwork Prince (The Infernal Devices, #2)", "Cassandra Clare"),
266("City of Fallen Angels (The Mortal Instruments, #4)", "Cassandra Clare"),
267("Marked (House of Night, #1)", "P.C. Cast"),
268("The Lost Hero (The Heroes of Olympus, #1)", "Rick Riordan"),
269("The Silence of the Lambs  (Hannibal Lecter, #2)", "Thomas Harris"),
270("The Screwtape Letters", "C.S. Lewis"),
271("The Iliad/The Odyssey", "Homer"),
272("The Trial", "Franz Kafka"),
273("Midnight Sun (Twilight, #1.5)", "Stephenie Meyer"),
274("Ella Enchanted", "Gail Carson Levine"),
275("The Phantom of the Opera", "Gaston Leroux"),
276("The Sound and the Fury", "William Faulkner"),
277("The Wind-Up Bird Chronicle", "Haruki Murakami"),
278("Man's Search for Meaning", "Viktor E. Frankl"),
279("The Shack", "William Paul Young"),
280("Roots: The Saga of an American Family", "Alex Haley"),
281("The Night Circus", "Erin Morgenstern"),
282("Fear and Loathing in Las Vegas", "Hunter S. Thompson"),
283("Blindness", "José Saramago"),
284("Island of the Blue Dolphins (Island of the Blue Dolphins, #1)", "Scott O'Dell"),
285("Stranger in a Strange Land", "Robert A. Heinlein"),
286("The Complete Calvin and Hobbes", "Bill Watterson"),
287("Delirium (Delirium, #1)", "Lauren Oliver"),
288("For Whom the Bell Tolls", "Ernest Hemingway"),
289("I Know This Much Is True", "Wally Lamb"),
290("The Selection (The Selection, #1)", "Kiera Cass"),
291("Beautiful Disaster (Beautiful, #1)", "Jamie McGuire"),
292("The Guernsey Literary and Potato Peel Pie Society", "Mary Ann Shaffer"),
293("White Oleander", "Janet Fitch"),
294("The House of the Spirits", "Isabel Allende"),
295("A Clash of Kings  (A Song of Ice and Fire, #2)", "George R.R. Martin"),
296("The Vampire Lestat (The Vampire Chronicles, #2)", "Anne Rice"),
297("Lamb: The Gospel According to Biff, Christ's Childhood Pal", "Christopher Moore"),
298("The Once and Future King (The Once and Future King #1-4)", "T.H. White"),
299("Othello", "William Shakespeare"),
300("The Girl Who Kicked the Hornet's Nest (Millennium, #3)", "Stieg Larsson"),
301("The Historian", "Elizabeth Kostova"),
302("King Lear", "William Shakespeare"),
303("Into the Wild", "Jon Krakauer"),
304("Flow Down Like Silver: Hypatia of Alexandria", "Ki Longfellow"),
305("The Idiot", "Fyodor Dostoyevsky"),
306("The Green Mile", "Stephen King"),
307("Paper Towns", "John Green"),
308("Uncle Tom's Cabin", "Harriet Beecher Stowe"),
309("James and the Giant Peach", "Roald Dahl"),
310("The Thirteenth Tale", "Diane Setterfield"),
311("Speak", "Laurie Halse Anderson"),
312("All Creatures Great and Small", "James Herriot"),
313("Neverwhere", "Neil Gaiman"),
314("Misery", "Stephen King"),
315("Leaves of Grass", "Walt Whitman"),
316("Invisible Man", "Ralph Ellison"),
317("Catching Fire (The Hunger Games, #2)", "Suzanne Collins"),
318("Where the Red Fern Grows", "Wilson Rawls"),
319("The Cider House Rules", "John Irving"),
320("Different Seasons", "Stephen King"),
321("Paradise Lost", "John Milton"),
322("Graceling (Graceling Realm, #1)", "Kristin Cashore"),
323("Inkheart (Inkworld, #1)", "Cornelia Funke"),
324("The Complete Works", "William Shakespeare"),
325("Candide", "Voltaire"),
326("Howl's Moving Castle (Howl's Moving Castle #1)", "Diana Wynne Jones"),
327("The Things They Carried", "Tim O'Brien"),
328("The Awakening", "Kate Chopin"),
329("Walden", "Henry David Thoreau"),
330("Sophie's Choice", "William Styron"),
331("Heidi", "Johanna Spyri"),
332("The Prince of Tides", "Pat Conroy"),
333("Are You There God? It's Me, Margaret", "Judy Blume"),
334("Throne of Glass (Throne of Glass, #1)", "Sarah J. Maas"),
335("Sophie's World", "Jostein Gaarder"),
336("Dead Until Dark (Sookie Stackhouse, #1)", "Charlaine Harris"),
337("Foundation (Foundation #1)", "Isaac Asimov"),
338("The Monster at the End of this Book", "Jon Stone"),
339("The Time Machine", "H.G. Wells"),
340("City of Lost Souls (The Mortal Instruments, #5)", "Cassandra Clare"),
341("Cinder (The Lunar Chronicles, #1)", "Marissa Meyer"),
342("Norwegian Wood", "Haruki Murakami"),
343("The Complete Sherlock Holmes", "Arthur Conan Doyle"),
344("Fifty Shades Darker (Fifty Shades, #2)", "E.L. James"),
345("Franny and Zooey", "J.D. Salinger"),
346("Fried Green Tomatoes at the Whistle Stop Cafe", "Fannie Flagg"),
347("Bridget Jones's Diary (Bridget Jones, #1)", "Helen Fielding"),
348("The Power of One (The Power of One, #1)", "Bryce Courtenay"),
349("The Secret History", "Donna Tartt"),
350("Middlemarch", "George Eliot"),
351("The Magician's Nephew (Chronicles of Narnia, #6)", "C.S. Lewis"),
352("Things Fall Apart (The African Trilogy, #1)", "Chinua Achebe"),
353("The Son of Neptune (The Heroes of Olympus, #2)", "Rick Riordan"),
354("Kafka on the Shore", "Haruki Murakami"),
355("Bel Canto", "Ann Patchett"),
356("Cold Mountain", "Charles Frazier"),
357("The Complete Novels", "Jane Austen"),
358("A Short History of Nearly Everything", "Bill Bryson"),
359("Fifty Shades Freed (Fifty Shades, #3)", "E.L. James"),
360("Mrs. Dalloway", "Virginia Woolf"),
361("A Time to Kill", "John Grisham"),
362("Stardust", "Neil Gaiman"),
363("Gulliver's Travels", "Jonathan Swift"),
364("The Qur'an / القرآن الكريم", "Anonymous"),
365("A Portrait of the Artist as a Young Man", "James Joyce"),
366("If I Stay (If I Stay, #1)", "Gayle Forman"),
367("Allegiant (Divergent, #3)", "Veronica Roth"),
368("The Wise Man's Fear (The Kingkiller Chronicle, #2)", "Patrick Rothfuss"),
369("Never Let Me Go", "Kazuo Ishiguro"),
370("Beautiful Creatures (Caster Chronicles, #1)", "Kami Garcia"),
371("Black Beauty", "Anna Sewell"),
372("Number the Stars", "Lois Lowry"),
373("Dark Lover (Black Dagger Brotherhood, #1)", "J.R. Ward"),
374("The Art of Racing in the Rain", "Garth Stein"),
375("Legend (Legend, #1)", "Marie Lu"),
376("Eldest (The Inheritance Cycle, #2)", "Christopher Paolini"),
377("The Witches", "Roald Dahl"),
378("V for Vendetta", "Alan Moore"),
379("Love You Forever", "Robert Munsch"),
380("The Hound of the Baskervilles (Sherlock Holmes, #5)", "Arthur Conan Doyle"),
381("A Separate Peace", "John Knowles"),
382("The Gunslinger (The Dark Tower, #1)", "Stephen King"),
383("Go Ask Alice", "Beatrice Sparks (as "Anonymous")"),
384("As I Lay Dying", "William Faulkner"),
385("Fangirl", "Rainbow Rowell"),
386("Mansfield Park", "Jane Austen"),
387("The Tell-Tale Heart and Other Writings", "Edgar Allan Poe"),
388("Dear John", "Nicholas Sparks"),
389("Tuck Everlasting", "Natalie Babbitt"),
390("The Mark of Athena (The Heroes of Olympus, #3)", "Rick Riordan"),
391("Crescendo (Hush, Hush, #2)", "Becca Fitzpatrick"),
392("White Fang", "Jack London"),
393("My Ántonia", "Willa Cather"),
394("The Amazing Adventures of Kavalier & Clay", "Michael Chabon"),
395("Do Androids Dream of Electric Sheep?", "Philip K. Dick"),
396("Gone Girl", "Gillian Flynn"),
397("Beowulf", "Unknown"),
398("The Firm", "Robin A.H. Waterfield"),
399("Brisingr  (The Inheritance Cycle, #3)", "Christopher Paolini"),
400("The Last Song", "Nicholas Sparks"),
401("The Graveyard Book", "Neil Gaiman"),
402("The English Patient", "Michael Ondaatje"),
403("Midnight's Children", "Salman Rushdie"),
404("Obsidian (Lux, #1)", "Jennifer L. Armentrout"),
405("Stargirl (Stargirl, #1)", "Jerry Spinelli"),
406("Eleanor & Park", "Rainbow Rowell"),
407("A Child Called "It" (Dave Pelzer #1)", "Dave Pelzer"),
408("Zen and the Art of Motorcycle Maintenance: An Inquiry Into Values", "Robert M. Pirsig"),
409("Doctor Zhivago", "Boris Pasternak"),
410("Evermore (The Immortals, #1)", "Alyson Noel"),
411("Like Water for Chocolate", "Laura Esquivel"),
412("Tao Te Ching", "Lao Tzu"),
413("The Eye of the World (Wheel of Time, #1)", "Robert Jordan"),
414("The Martian Chronicles", "Ray Bradbury"),
415("The Amber Spyglass (His Dark Materials, #3)", "Philip Pullman"),
416("Breakfast at Tiffany's", "Truman Capote"),
417("The Complete Maus (Maus, #1-2)", "Art Spiegelman"),
418("Robinson Crusoe", "Daniel Defoe"),
419("The Angel Experiment (Maximum Ride, #1)", "James Patterson"),
420("Inferno (The Divine Comedy #1)", "Dante Alighieri"),
421("Steppenwolf", "Hermann Hesse"),
422("The Hunchback of Notre-Dame", "Victor Hugo"),
423("'Salem's Lot", "Stephen King"),
424("The Diary of a Young Girl", "Anne Frank"),
425("The Origin of Species", "Charles Darwin"),
426("Dragonfly in Amber (Outlander, #2)", "Diana Gabaldon"),
427("The Subtle Knife (His Dark Materials, #2)", "Philip Pullman"),
428("A Streetcar Named Desire", "Tennessee Williams"),
429("Snow Flower and the Secret Fan", "Lisa See"),
430("Cloud Atlas", "David Mitchell"),
431("A Fine Balance", "Rohinton Mistry"),
432("Shatter Me (Shatter Me, #1)", "Tahereh Mafi"),
433("Death of a Salesman", "Arthur Miller"),
434("Faust: First Part", "Johann Wolfgang von Goethe"),
435("The Scarlet Pimpernel", "Emmuska Orczy"),
436("The Shipping News", "Annie Proulx"),
437("The BFG", "Roald Dahl"),
438("Midnight in the Garden of Good and Evil: A Savannah Story", "John Berendt"),
439("Breakfast of Champions", "Kurt Vonnegut"),
440("Anna and the French Kiss (Anna and the French Kiss, #1)", "Stephanie Perkins"),
441("American Psycho", "Bret Easton Ellis"),
442("Mockingjay (The Hunger Games, #3)", "Suzanne Collins"),
443("High Fidelity", "Nick Hornby"),
444("Houdini Heart", "Ki Longfellow"),
445("The Chosen", "Chaim Potok"),
446("The Prince", "Niccolò Machiavelli"),
447("Room", "Emma Donoghue"),
448("Hopeless (Hopeless, #1)", "Colleen Hoover"),
449("Matched (Matched, #1)", "Ally Condie"),
450("Betrayed (House of Night, #2)", "P.C. Cast"),
451("The Reader", "Bernhard Schlink"),
452("Nineteen Minutes", "Jodi Picoult"),
453("The Plague", "Albert Camus"),
454("Daughter of Smoke & Bone (Daughter of Smoke & Bone, #1)", "Laini Taylor"),
455("Me Before You (Me Before You, #1)", "Jojo Moyes"),
456("Infinite Jest", "David Foster Wallace"),
457("The Tales of Beedle the Bard", "J.K. Rowling"),
458("The Virgin Suicides", "Jeffrey Eugenides"),
459("Untamed (House of Night, #4)", "P.C. Cast"),
460("Flowers in the Attic (Dollanganger, #1)", "V.C. Andrews"),
461("The Remains of the Day", "Kazuo Ishiguro"),
462("Jonathan Strange & Mr Norrell", "Susanna Clarke"),
463("Unbroken: A World War II Story of Survival, Resilience, and Redemption",
464"Laura Hillenbrand"),
465("Lover Awakened (Black Dagger Brotherhood, #3)", "J.R. Ward"),
466("The Final Empire (Mistborn, #1)", "Brandon Sanderson"),
467("The Age of Innocence", "Edith Wharton"),
468("City of Heavenly Fire (The Mortal Instruments, #6)", "Cassandra Clare"),
469("Divine Secrets of the Ya-Ya Sisterhood", "Rebecca Wells"),
470("Artemis Fowl (Artemis Fowl, #1)", "Eoin Colfer"),
471("Blood Meridian, or the Evening Redness in the West", "Cormac McCarthy"),
472("Redeeming Love", "Francine Rivers"),
473("Chosen (House of Night, #3)", "P.C. Cast"),
474("Neuromancer", "William Gibson"),
475("The Waste Land", "T.S. Eliot"),
476("A Feast for Crows (A Song of Ice and Fire, #4)", "George R.R. Martin"),
477("The Pearl", "John Steinbeck"),
478("The Way of Kings (The Stormlight Archive, #1)", "Brandon Sanderson"),
479("Ready Player One", "Ernest Cline"),
480("Me Talk Pretty One Day", "David Sedaris"),
481("Northanger Abbey", "Jane Austen"),
482("Shantaram", "Gregory David Roberts"),
483("The Devil in the White City: Murder, Magic, and Madness at the Fair That),
484(Changed America", "Erik Larson"),
485("The Twilight Collection (Twilight, #1-3)", "Stephenie Meyer"),
486("The Jungle", "Upton Sinclair"),
487("Snow Falling on Cedars", "David Guterson"),
488("Pippi Longstocking", "Astrid Lindgren"),
489("Everything Is Illuminated", "Jonathan Safran Foer"),
490("The Voyage of the Dawn Treader (Chronicles of Narnia, #3)", "C.S. Lewis"),
491("Waiting for Godot", "Samuel Beckett"),
492("To the Lighthouse", "Virginia Woolf"),
493("The Lost Symbol (Robert Langdon, #3)", "Dan Brown"),
494("Dubliners", "James Joyce"),
495("Wonder", "R.J. Palacio"),
496("The Strange Case of Dr. Jekyll and Mr. Hyde", "Robert Louis Stevenson"),
497("Blood River: A Journey to Africa's Broken Heart", "Tim Butcher"),
498("The Last Battle (Chronicles of Narnia, #7)", "C.S. Lewis"),
499("A Room with a View", "E.M. Forster"),
500("Torment (Fallen, #2)", "Lauren Kate"),
501("I, Claudius (Claudius, #1)", "Robert Graves"),
502("The Iron King (The Iron Fey, #1)", "Julie Kagawa"),
503("Bloodlines (Bloodlines, #1)", "Richelle Mead"),
504("I, Robot (Robot #0.1)", "Isaac Asimov"),
505("Three Cups of Tea: One Man's Mission to Promote Peace ... One School at a),
506(Time", "Greg Mortenson"),
507("The Mortal Instruments Boxed Set: City of Bones; City of Ashes; City of Glass),
508((The Mortal Instruments, #1-3)", "Cassandra Clare"),
509("Brideshead Revisited", "Evelyn Waugh"),
510("Johnny Got His Gun", "Dalton Trumbo"),
511("Bleak House", "Charles Dickens"),
512("Miss Peregrine’s Home for Peculiar Children (Miss Peregrine’s Peculiar),
513(Children, #1)", "Ransom Riggs"),
514("Vanity Fair", "William Makepeace Thackeray"),
515("Carrie", "Stephen King"),
516("Bared to You (Crossfire, #1)", "Sylvia Day"),
517("11/22/63", "Stephen King"),
518("The Witching Hour (Lives of the Mayfair Witches, #1)", "Anne Rice"),
519("Halfway to the Grave (Night Huntress, #1)", "Jeaniene Frost"),
520("A Dance with Dragons (A Song of Ice and Fire, #5)", "George R.R. Martin"),
521("The God Delusion", "Richard Dawkins"),
522("I Know Why the Caged Bird Sings", "Maya Angelou"),
523("Voyager (Outlander, #3)", "Diana Gabaldon"),
524("Harry Potter Boxset (Harry Potter, #1-7)", "J.K. Rowling"),
525("The Exorcist", "William Peter Blatty"),
526("Chocolat (Chocolat, #1)", "Joanne Harris"),
527("A Great and Terrible Beauty (Gemma Doyle, #1)", "Libba Bray"),
528("The Complete Poems", "Emily Dickinson"),
529("The House of Hades (The Heroes of Olympus, #4)", "Rick Riordan"),
530("Perfect Chemistry (Perfect Chemistry, #1)", "Simone Elkeles"),
531("The Republic", "Plato"),
532("Of Human Bondage", "W. Somerset Maugham"),
533("Wizard's First Rule (Sword of Truth, #1)", "Terry Goodkind"),
534("Are You My Mother?", "P.D. Eastman"),
535("The Summoning (Darkest Powers, #1)", "Kelley Armstrong"),
536("Cannery Row", "John Steinbeck"),
537("North and South", "Elizabeth Gaskell"),
538("Snow Crash", "Neal Stephenson"),
539("You Are Special (Wemmicksville, #1)", "Max Lucado"),
540("Cry, the Beloved Country", "Alan Paton"),
541("World War Z: An Oral History of the Zombie War", "Max Brooks"),
542("Just Listen", "Sarah Dessen"),
543("The One (The Selection, #3)", "Kiera Cass"),
544("The Lord of the Rings (The Lord of the Rings, #1-3)", "J.R.R. Tolkien"),
545("The 5th Wave (The 5th Wave, #1)", "Rick Yancey"),
546("Dead to the World (Sookie Stackhouse, #4)", "Charlaine Harris"),
547("The Truth About Forever", "Sarah Dessen"),
548("The Unbecoming of Mara Dyer (Mara Dyer, #1)", "Michelle Hodkin"),
549("Acheron (Dark-Hunter #14)", "Sherrilyn Kenyon"),
550("Lady Chatterley's Lover", "D.H. Lawrence"),
551("Hunted (House of Night, #5)", "P.C. Cast"),
552("Ishmael: An Adventure of the Mind and Spirit", "Daniel Quinn"),
553("Unwind (Unwind, #1)", "Neal Shusterman"),
554("Silence (Hush, Hush, #3)", "Becca Fitzpatrick"),
555("Nine Stories", "J.D. Salinger"),
556("The Glass Menagerie", "Tennessee Williams"),
557("The Woman in White", "Wilkie Collins"),
558("East of Eden", "John Steinbeck"),
559("The Polar Express", "Chris Van Allsburg"),
560("I Am Number Four (Lorien Legacies, #1)", "Pittacus Lore"),
561("The War of the Worlds", "H.G. Wells"),
562("Much Ado About Nothing", "William Shakespeare"),
563("The Bronze Horseman (The Bronze Horseman, #1)", "Paullina Simons"),
564("Wicked Lovely (Wicked Lovely, #1)", "Melissa Marr"),
565("The Hours", "Michael Cunningham"),
566("The Last Lecture", "Randy Pausch"),
567("The Bean Trees (Greer Family, #1)", "Barbara Kingsolver"),
568("Being and Time", "Martin Heidegger"),
569("Twelfth Night", "William Shakespeare"),
570("I Capture the Castle", "Dodie Smith"),
571("The Arabian Nights", "Anonymous"),
572("A Discovery of Witches (All Souls Trilogy, #1)", "Deborah Harkness"),
573("Demian. Die Geschichte von Emil Sinclairs Jugend", "Hermann Hesse"),
574("Sarah's Key", "Tatiana de Rosnay"),
575("Swann's Way (In Search of Lost Time, #1)", "Marcel Proust"),
576("Cyrano de Bergerac", "Edmond Rostand"),
577("Into Thin Air: A Personal Account of the Mount Everest Disaster", "Jon Krakauer"),
578("The Martian", "Andy Weir"),
579("The Host (The Host, #1)", "Stephenie Meyer"),
580("Interpreter of Maladies", "Jhumpa Lahiri"),
581("Coraline", "Neil Gaiman"),
582("The Horse and His Boy (Chronicles of Narnia, #5)", "C.S. Lewis"),
583("Crown of Midnight (Throne of Glass, #2)", "Sarah J. Maas"),
584("P.S. I Love You", "Cecelia Ahern"),
585("Slammed (Slammed, #1)", "Colleen Hoover"),
586("All the King's Men", "Robert Penn Warren"),
587("The Goose Girl (The Books of Bayern, #1)", "Shannon Hale"),
588("Angelfall (Penryn & the End of Days, #1)", "Susan Ee"),
589("Sabriel (Abhorsen,  #1)", "Garth Nix"),
590("World Without End (The Pillars of the Earth, #2)", "Ken Follett"),
591("Peace Like a River", "Leif Enger"),
592("Far from the Madding Crowd", "Thomas Hardy"),
593("Lover Eternal (Black Dagger Brotherhood, #2)", "J.R. Ward"),
594("Julius Caesar", "William Shakespeare"),
595("The Merchant of Venice", "William Shakespeare"),
596("The Red Pyramid (Kane Chronicles, #1)", "Rick Riordan"),
597("The Elite (The Selection, #2)", "Kiera Cass"),
598("Before I Fall", "Lauren Oliver"),
599("Pet Sematary", "Stephen King"),
600("2001: A Space Odyssey (Space Odyssey, #1)", "Arthur C. Clarke"),
601("Mythology: Timeless Tales of Gods and Heroes", "Edith Hamilton"),
602("Little House in the Big Woods (Little House, #1)", "Laura Ingalls Wilder"),
603("Speaker for the Dead (Ender's Saga, #2)", "Orson Scott Card"),
604("Little House on the Prairie (Little House, #2)", "Laura Ingalls Wilder"),
605("Gone (Gone, #1)", "Michael  Grant");