SQL Database project
Budget: $30 – $250 USD
ToDo List version 4
Create a web application to store a to-do list.
Basic characteristics
No user identification needed.
The current user can see all the tasks.
Data
Tasks
Each task consists of
Task description (required)
Due date (required)
Task category (optional)
Priority level (optional) (Values: 1-4, where 1 is the highest priority)
Status (active or completed)
(Optional) means is optional to the user. So, the user does not have to provided that information. However, the database must store that information, if provided.
Categories
Each task category consists of
Name
Parent category
Another existing category which does not have a parent category.
If the current category is already a parent category of another one, this attribute cannot be modified.
Functionalities
Current user can create tasks.
Current user can mark a task as completed.
Current user can create categories.
Current user can edit categories (and subcategories).
A category may have a parent category. A category with a parent category is called a subcategory.
Views or reports
The default list view of the application will show overdue tasks and due-today tasks. Tasks will be sorted by priority.
The user can select a view for only completed tasks on a specific day. Tasks will be sorted by due date.
The user can select a report for a specific week. This report will show the day and the number of the tasks completed per each day and in total.
Create a web application to store a to-do list.
Basic characteristics
No user identification needed.
The current user can see all the tasks.
Data
Tasks
Each task consists of
Task description (required)
Due date (required)
Task category (optional)
Priority level (optional) (Values: 1-4, where 1 is the highest priority)
Status (active or completed)
(Optional) means is optional to the user. So, the user does not have to provided that information. However, the database must store that information, if provided.
Categories
Each task category consists of
Name
Parent category
Another existing category which does not have a parent category.
If the current category is already a parent category of another one, this attribute cannot be modified.
Functionalities
Current user can create tasks.
Current user can mark a task as completed.
Current user can create categories.
Current user can edit categories (and subcategories).
A category may have a parent category. A category with a parent category is called a subcategory.
Views or reports
The default list view of the application will show overdue tasks and due-today tasks. Tasks will be sorted by priority.
The user can select a view for only completed tasks on a specific day. Tasks will be sorted by due date.
The user can select a report for a specific week. This report will show the day and the number of the tasks completed per each day and in total.