Bar Beer Drinker is about a number of fictional bars and their sales. The bars sell only beers and food items. A number of customers ("drinkers") order beers and/or food from the given bars, for which transactions ("bills") are issued. This project explores order bills issued between 6 Oct 2018 and 20 Nov 2018, in order to derive interesting facts about how the bars' businesses were doing at the time. Information about the bars, beers, drinkers, and bills are stored in a relational database. Any information used in this project is fictional.
The front-end website showed several patterns of customer spending derived from the transaction data, that the bars may find helpful to create their business strategies that would increase their profit.
Please see the Wiki of this repository for the following:
- Wiki Home | Introduction to the Database
- Bar Beer Drinker Website | Video tutorial of the Front-End
- Entity-Relationship Diagram | Database Schema and Entity-Relationship Diagram
- SQL queries | SQL queries used in Bar Beer Drinker
This Excel file contains data in the relational database of Bar Beer Drinker. The file has multiple sheets. Each sheet is a table, and the sheet names are the table names. The first row of the sheets are the keys of the table.
- HTML, JavaScript, Python, AngularJS, NodeJS
- SQL, MySQL, Amazon RDS, Heroku
Team Member(s)
- Yeongeun Kwon