1 / 17

Database Assignment

Database Assignment. Third Thursday Book Club Picks. Jean Mead LS560. Hart County Library Website. Website & Changes.

sidney
Download Presentation

Database Assignment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Assignment Third Thursday Book Club Picks Jean Mead LS560

  2. Hart County Library Website

  3. Website & Changes • The Hart County Library Website does not have a search option on the site for our patrons to search anything, including events or books that the Third Thursday Book Club have read. • Since I facilitate the book club, my goal is to create a tool that patrons and the facilitator can use to search books read in book club according to a variety of data points such as: author name, date read or book title. • I created three tables: Author, Books, and Date.

  4. Tables • I created three tables. • The Author table has an ID number, First Name and Last Name • The Book Table has Book ID number, Title, Author ID number, Book type (Fic or Non Fic) and Genre. • The Date Table has the Date Read, Author ID number and Book ID number.

  5. Author Table

  6. Book Table

  7. Date Table

  8. Relationships My relationships were: From Author table to Book table: Author ID to Author ID & Last Name to Title. The relationship between Book table and Date table was Book ID to Book ID.

  9. Query 1: • How many books by Sarah Addison Allen have we read in book club? • SELECT "Authors"."Last Name", "Books"."Title", "Date"."Date Read" FROM "Books", "Authors", "Date" WHERE "Books"."AuthorID" = "Authors"."Author ID" AND "Date"."BookID" = "Books"."BookID" AND "Authors"."Last Name" = 'Allen' ORDER BY "Authors"."Last Name" ASC • Answer: 2. “Garden Spells” in 2012 and “The Girl that Chased the Moon” in 2013.

  10. Query 1:

  11. Answer: 2 books

  12. Query 2: • When did we read the book “Blue” • SELECT "Authors"."Last Name", "Books"."Title", "Date"."Date Read" FROM "Books", "Authors", "Date" WHERE "Books"."AuthorID" = "Authors"."Author ID" AND "Date"."BookID" = "Books"."BookID" AND "Books"."Title" = 'Blue' ORDER BY "Books"."Title" ASC • Answer: 4/1/10

  13. Query 2: When did we read “Blue”

  14. Answer: “Blue” was read 4/1/10

  15. Website changes/mock up • The best place to put the book club information is on the left menu. • I would add a “Third Thursday Book Club” Information Button for the patrons to click on and have it send them to an advanced search form.

  16. Website changes

  17. Mock up of Form Third Thursday Book Club We meet every third Thursday at 6pm in the small meeting room. Want to see if we have read your favorite book? Or what we have read in the past? Search the Database! • By Book Title Search • By Date Read Search • By Author Name Search

More Related