Question: Our project aims to create a user-friendly task management system. Each user will be able to create an account with their credentials and then will

Our project aims to create a user-friendly task management system. Each user will be able to create an account with their credentials and then will be able to login to the system. After their registrations, customers can change their login credentials anytime they wish to. After logging in to the system, users can look at their tasks, their deadline, status, priority, comments and task explanations. There will be sub tasks for bigger tasks. There will be an admin user to manage project permissions. That admin account will be able to give and take back permissions from other users using role-based permission system. Admin account will be able to create, delete and modify projects too. Every user will be able to create a task and change the status of the tasks too but only admin account will have the permission to completely delete them .Users will see when they are mentioned by notifications. Guest look will be implemented too but they will only see the projects admins set public and they wont be able to make any change. System will create a project summary report that contains average task completion time, longest task, task count, project completion time and project. This report will contain how many tasks and sub-tasks every person involved in.I need a relational diagram of this database project which i can later on implement in Microsoft SQL server management studio 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!