Project Plan and ER Diagram

[thallapareddyr]

Project Components: Users Table: Fields: ID, username, password, email, role (admin/regular user), etc. Tasks Table: Fields: ID, title, description, due date, status, creator (user ID), category ID, etc. Task Categories Table: Fields: ID, name, description, etc. Task Assignments Table: Fields: ID, task ID, assigned to (user ID), assigned by (user ID), date assigned, etc.

Web Pages & Functionalities: Login/Registration Page:

Functionality: User authentication and registration for regular users and administrators. Dashboard:

Regular Users: View assigned tasks, create new tasks, view task details, update task status. Administrators: Access to all tasks, assign tasks to users, manage task categories. Task Creation Page:

Regular Users: Create a new task, assign it to oneself or others, set due dates and categories. Task Tracking Page:

Both User Types: View tasks assigned, filter tasks by status, due dates, or categories. Reporting Page:

Administrators: Generate reports on tasks completed, pending, overdue, etc. Email Notifications:

System sends notifications when: Task is assigned. Task status changes (e.g., completed, overdue). Reminder for approaching due dates.

[thallapareddyr]

ER Diagram