Capstone Project Spring 2025 - Team 8
Jake's on Devine, located at 2112 Devine Street in Columbia, South Carolina, is a beloved bar and grill known for its dog friendly, and fun atmosphere. Jake's offers patrons a blend of good food, a diverse selection of craft beers, and engaging events.
Contact: Kyle Stiffler or Dr. Nick Stiffler. nstiffler1@udayton.edu
Jakes on Devine is an innovative platform that aims to revolutionize the way restaurant orders are managed, focusing on simplicity, speed, and customer satisfaction. The project leverages cutting-edge technologies and modern UI/UX principles to deliver a seamless experience for both restaurant staff and customers.
During Month One, our team spent the beginning of the month understanding the scope of our project. Dr. Stiffler was able to introduce us to the idea of a POS (Point of Sale) system, and we narrowed down what this design could look like. Minor details like types of data we could test with, ideas for databases, and even the tech stack possibilities were discussed in this first meeting.
Began formulating our schema that would ultimately be the test data for our databases/inventory.
.png)
The previous Capstone I database, which used MongoDB, was tested and showed several flaws and disadvantages. The schema that had been created earlier was used for the testing. Then, a new database technology, Neo4J, was tested based on Dr. Stiffler's recommendation. Neo4J turned out to be much easier to use, with visual data representation that made analysis simpler. Although the final decision on the database hadn't been fully made, Neo4J was fully developed and was expected to be the go-to choice for the POS system.
Designed early-stage schema and planned data relationships for items, orders, and categories.
In Month Two, our team found its rhythm after a somewhat irregular start in Month One. With more consistent team meetings and a few check-ins with our client, Dr. Stiffler, we were able to align on project expectations and make significant progress.
We focused on building a working SQLite3 database and Python script that could be run on all team members' devices. The script rebuilds the database on each run, enabling easy updates. With the help of Dr. Stiffler’s GitHub scripts, and after learning how to use SQLite and Pandas, we successfully created and displayed the database using two scripts. This allowed us to view data in a clean table format and ensure consistent local copies across all machines.
Front-end development took place alongside backend work. Using Figma, we created several application screen mockups. Figma's intuitive tools and educational development features allowed us to convert designs into usable code for our stylesheets and front-end files within the repository.
After confirming database-to-browser connectivity, we evolved from a basic black-screen text display to a structured button layout inspired by our Figma designs. This layout introduced a hierarchy that mirrored the simplicity of platforms like Toast. We then implemented features such as a search bar, a dynamic receipt display, subtotal/tax/total calculators, and automatic tip buttons—all styled with CSS based on our Figma designs. Scroll to Month 3 to see our working front-end!
During Month Three, our team made the final fixes to some UI bugs and accessibility modes, we added PIN login functionality for two user types, created the logout button, and began this documentation for the project. We put a bow on the project, and presented our final product to the University of Dayton Department of Computer Science on April 28, 2025.
Please watch our full demo here!
And find our database creation demo here!
