Cookie Jar Website
A full stack and interactive online bakery website!
Tools
Node.Js, JavaScript, SQL, HTML, CSS, API endpoints
Project Introduction
Timeline
3 weeks (Fall 2023)
Group
Isha Narayanan, Chloe Adams
For our final project, we were tasked with creating and end-to-end website application. My partner and I decided to create an online bakery called the Cookiejar! For our application we created: a SQL database with 6 tables, 9 unique API endpoints, and an interactive website using HTML, CSS, and JavaScript. This project was difficult yet rewarding and I learned a lot through completing it!
SQL Database
Context
Web Programming (CSE 154) Final Project
We created 5 data tables in our database: filters, products, reviews, transactions and users.
Filters
Used to filter products by category on main page
Reviews
Catalogs reviews on all products, updated when new reviews are entered by users
Users
Catalogs all users that have successfully created an account
Website Features
In total, we implemented 8 website features. We achieved this by creating 9 API endpoints to retrieve information from our SQL database. Using this information, we utilized JavaScript, HTML, and CSS to correspondingly update our website.
Login
Expanded View
Leave feedback on a product
Design System
Products
Keeps a catalog of all available products, rating-score and quantity are updated according to user input
Transactions
Catalogs every transaction that has successfully been completed, updated with new transactions
Create a new user
Search and filter the available items
View all previous transactions
Display bakery items on main page
Buy a product
