local brewery database for free the hops n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Local brewery database for Free the HOps PowerPoint Presentation
Download Presentation
Local brewery database for Free the HOps

Loading in 2 Seconds...

play fullscreen
1 / 10

Local brewery database for Free the HOps - PowerPoint PPT Presentation


  • 155 Views
  • Uploaded on

Local brewery database for Free the HOps. Courtney Cummings LS-560. Free the Hops. Free the Hops is a grassroots non-profit organization whose mission is to help bring quality beer to the state of Alabama and campaign to change brewing laws for local brewers and homebrewers .

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Local brewery database for Free the HOps' - isabel


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
free the hops
Free the Hops

Free the Hops is a grassroots non-profit organization whose mission is to help bring quality beer to the state of Alabama and campaign to change brewing laws for local brewers and homebrewers.

Currently, the Free the Hops website (www.freethehops.org/) features helpful information about beer and brewing in Alabama; however, it does not include a search function to help users find local breweries in the state.

local brewery database
Local Brewery Database

I created a database that lists all local breweries, taprooms, and brewpubs in the states of Alabama to help users find a local establishment.

Using my database, users can find a local establishment (brewery, taproom, or brewpub) breweries for an area of Alabama (North, Central, or South) or by city.

Once they find a brewery, they can find the address or website for that brewery.

database tables
Database Tables

Six database tables were added to correctly list and link the brewery name, address, city, area, website with brewery type.

On the left, you’ll see an image of the Brewery table, which includes a majority of the linked data.

table relationships
Table relationships

Relationships were created among all pertinent pieces of information.

For example, brewery names were linked to the appropriate address, website, brewery type, and area.

Addresses were linked to cities and areas.

sql queries
SQL queries

To test the database structure, two queries were created.

On the right, you’ll see the query to list the taprooms available in Birmingham, Alabama and their corresponding street addresses.

The results display in the table on the right.

sql queries1
Sql queries

The second query searches for all Huntsville, Alabama brewpubs with their websites.

Results of the query display in the table on on the right.

adding the database to free the hops
Adding the database to Free the Hops
  • I propose adding a search box to the Free the Hops homepage in the top right corner to help users search for a local brewer.
  • Users can search for a brewery’s name or a city name.
  • Results would display on a second page, listing the brewery’s website and street address.
search box on free the hops website
Search box on Free the Hops website

The search box would help users search for local breweries

search results on free the hops website
Search results on Free the Hops Website

Search results could list the street address and website for the searched city or brewery name.