1 / 13

LS 560: Database Project Tonya Olson

LS 560: Database Project Tonya Olson. April 14, 2014. The Problem…. LS 560 required students to build a website. As part of this assignment, I included a section entitled “Literary Loves” highlighting my favorite books and a link to my Goodreads page.

farrah
Download Presentation

LS 560: Database Project Tonya Olson

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. LS 560: Database ProjectTonya Olson April 14, 2014

  2. The Problem… LS 560 required students to build a website. As part of this assignment, I included a section entitled “Literary Loves” highlighting my favorite books and a link to my Goodreads page. While my Goodreads page details books that I’ve read and want to read, I thought it would be interesting to have a section that details the many books I own, including those that I have not read.

  3. The Solution… Build a database!The database I built contains a selection of books contained in my personal library. A more comprehensive database would include all the books in my collection, but because of time and skill restrictions, I kept it smaller. My database containedthe following tables: • Authors • Books • Favorites • Gender • Genre

  4. Author Table

  5. Books Table

  6. Gender Table Genre Table Favorite Table

  7. Table Relationships

  8. Query #1 For my first query, I wanted to see which books I own, but have not read yet. When viewed in SQL format, it appears like this: In design view,it appears like this: And the results are:

  9. Query #2 For my second query, I wanted to see which books I consider my favorites AND are written by women. When viewed inSQL format, it appears like this: In design view,it appears like this:

  10. Query #2(continued) And the results are:

  11. Website Mock-Up as well as buttons toaccess the results ofthe two queries.If time had allowed,I think more queriescould make this taban interesting way toget to know me andmy reading habits. In order to illustrate my website’s database integration, I’ve added a tab called “My Library” which features the selection of books, Mock-Ups canalso be found at:http://bit.ly/QhDzFK

  12. Query #1 Results Mock-Up

  13. Query #2 Results Mock-Up

More Related