Transcript Database Presentation

+
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.
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 contained
the following tables:

Authors

Books

Favorites

Gender

Genre
+
Author Table
+
Books Table
+
Gender Table
Genre Table
Favorite Table
+
Table Relationships
+
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 in
SQL format, it appears like this:
In design view,
it appears like this:
+
Query #2
(continued)
And the results are:
+
Website Mock-Up
In order to illustrate my website’s database integration, I’ve added
a tab called “My Library” which features the selection of books,
as well as buttons to
access the results of
the two queries.
If time had allowed,
I think more queries
could make this tab
an interesting way to
get to know me and
my reading habits.
Mock-Ups can
also be found at:
http://bit.ly/QhDzFK
+
Query #1 Results Mock-Up
+
Query #2 Results Mock-Up