130 likes | 230 Views
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.
E N D
LS 560: Database ProjectTonya 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. 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.
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
Gender Table Genre Table Favorite Table
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:
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:
Query #2(continued) And the results are:
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