The Archivistís Beer Vault (ABV) is a database that I have worked on since my second semester at UNT. Initially it was just a simple beer database built using a fairly low tech software for SLIS 5200 Introduction to Information Organization. For my term project in SLIS 5707 Data Modeling for Information Professionals we were tasked to devise a multiple entity database and create it using Microsoft Access, with some hints of SQL. Converting the ABV into a multi entity database was a bit perplexing but once I figured out the entity-relationship diagram it was smooth sailing. Later in SLIS 5717 Dynamic WWW Control Structures, I learned about how to query SQL databases using PHP. Little by little more functions that I envisioned during my initial brainstorm became realities. It currently stands as a mix of a fictional store front and a database with far more detail than presented. I am still figuring out how to best display certain data so elements like Distributor information are sitting idle. For now the only real functions are purchase and adding beers to the database.
There is still plenty of work to be done and it has been a pleasure to develop so I hope to have a refined version further down the road. Such features include relevancy so I can add suggested beers with similar taste profiles and smarter browsing by food pairings. It has become an awesome side project.
Finally, a cheers to everyone who helped with this project. Here is a short list of those who made it possible:
And, of course, my lovely wife Meghann Hernandez... seen here enjoying a pint of Stanley Park Ice Breaker Winter Ale