Task Manage Service Website

(Database Management Systems Final Project)

GitHub Link: https://github.com/AOKins/TaskManageWebsiteService

As my part of a final project, I worked on creating a website that used a mySQL database to provide a service where users could create, and mark as complete, personal tasks that also fall under user-defined categories with assigned colors. Users could also give a basic shared functionality to other users.

The whole group project was broken into a mobile app created by one member, while I worked on the website counterpart. The end result is admittedly not a finished product, with only the most basic of security measures and many desired features not implemented by the end of our available time (for example, editing the tasks or better navigating across dates would've been beneficial for a more final product).

However, the project was a great learning experience as I created a Dart-based server that provided HTTP service with basic cookie implementation to create a persistent session for logged in user. It expanded my knowledge and familiarity with web development (HTML, CSS, and JS) as well as using the Dart language for the back-end. As part of being in the DBMS course, it also further practiced using MySQL in both setup and deployment of accessing it to create and edit data with embedded QL.

The following were features that were implemented (note that a lack of security was left as the project was proof of concept and focused more on the DBMS and web development side)

• Clients could create new accounts with requirement of new username and reiterate password

• Users could login, directing them to a homepage that provided tasks for today.

• Users could view an agenda page that showed tasks from today up to 1 week from today

• Users could create new tasks with assigned due date/time, title, description, and also set categories (or create new one)

• Categories set the colors of the tasks

• Users can share their categories to other users through username

• Users that own the category (not shared to them) can delete them