Task Manager in MySQL

Task Manager in MySQL

A database-driven task management system developed entirely in MySQL, designed to practice relational modeling, stored procedures, and view creation without relying on any external programming language.

The project includes tables for users, categories, and tasks, implementing relationships such as cascading deletes and nullable category references. Several stored procedures were created to perform CRUD operations directly from MySQL, and views were added to simplify queries for pending, overdue, or high-priority tasks.

Key features:

  • Database normalization and relational constraints (CASCADE and SET NULL).
  • Stored procedures for task creation, modification, and deletion.
  • SQL views for reporting (pending, overdue, high-priority, and by user).
  • Fully self-contained MySQL database—no external scripts required.

MySQL custom view
MySQL custom view
GitHub Page
Contact me!
LinkedInBehance