Moodi - Mood Tracking Application
This database project is the culmination of 11 weeks of collaborative work by Zachary Landry and Hope Matthews, during which we learned the fundamentals of database design, SQL, and web application development. The project focuses on building an admin-side system for a mood-tracking app that allows users to record their daily moods and associate activities with each entry.
Link to project: http://classwork.engr.oregonstate.edu:6023/index.html
Tech used: HTML, CSS, JavaScript, MySQL, Node.js, Express
This database was created using MySQL with schemas designed in MySQL Workbench. The web application uses static HTML with CSS for styling and client-side JavaScript for dynamic functionality, connected to a Node.js/Express backend.
-
Module 6: Exploration - Web Application Technology
- Source code and structure adapted from provided starter materials
- Canvas Link
-
Module 8: Exploration - Implementing CUD Operations
- Used for implementing create, update, and delete (CUD) functionality
- Canvas Link
Referenced throughout the project for front-end implementation:
- Flexbox layout techniques: CSS-Tricks Flexbox Guide
- Responsive design principles: web.dev Design Guide
- Box model, positioning, and styling concepts from CS290 lecture materials
- DOM manipulation examples: js-dom-manipulation
- JavaScript basics and patterns: js-fundamentals
- Event handling and callback patterns from course examples
-
HTTP request/response patterns: node-basics
-
Asynchronous communication concepts from course lectures
-
Fetch API implementation patterns
-
Course materials index: https://web.engr.oregonstate.edu/~hessro/teaching/cs290-sp22