Assignment 1: Task Management System Study the following problem Employees A company would like to implement a task management system to organize tasks the employees work on. An employee works on one or more tasks at a time, and a task can be assigned to many employees It is also important to keep track of the contributions employees make during working on a task Here is an example of the contributions employee Dave made for the "audit" task. Date/Time Contribution ldentified the accounts that need to be audited October 10, 2014 Prioritized the accounts that need to be audited October 13, 2014 Tasks A task can be broken into multiple subtasks. Each task has a description, deadline, a priority (high, medium, low), and a status (e.g. pending, completed, cancelled). Each task belongs to one project, but a project can have multiple tasks. Here is an example of some tasks (they are subtasks of the "schedule meeting" task) ID Description Deadline Status ioity parentTask 10 "Find people we need to 11 "book a room" 12 "arrange for coffee and September 15, 2014 "done" high"1 (schedule September 20,2014 "done"" October 1, 2014 invite" meeting) meeting) meeting) "done""medium 1 (schedule "pending""high"1(schedule drinks" Manage Tasks The system is expected to be used on a daily basis. For instance, every day in the morning, employees should be able to do things such as add a task, share a task with other employees, complete tasks, see how far a task has come, change some information about a task (e.g. postpone it), or perhaps write contributions to tasks. One of the challenges that employees face is that they are working on multiple tasks at the same time, and it is hard to know which one is urgent, overdue, etc. The system could help employees by providing an overview of the current tasks that draws the employee's attention to the important tasks. Question: Make an ER model that represents the system. Make sure you show the tables, attributes, relationships and participation. Make assumptions for anything you believe wasn't explicitly mentioned in the text Assignment 1: Task Management System Study the following problem Employees A company would like to implement a task management system to organize tasks the employees work on. An employee works on one or more tasks at a time, and a task can be assigned to many employees It is also important to keep track of the contributions employees make during working on a task Here is an example of the contributions employee Dave made for the "audit" task. Date/Time Contribution ldentified the accounts that need to be audited October 10, 2014 Prioritized the accounts that need to be audited October 13, 2014 Tasks A task can be broken into multiple subtasks. Each task has a description, deadline, a priority (high, medium, low), and a status (e.g. pending, completed, cancelled). Each task belongs to one project, but a project can have multiple tasks. Here is an example of some tasks (they are subtasks of the "schedule meeting" task) ID Description Deadline Status ioity parentTask 10 "Find people we need to 11 "book a room" 12 "arrange for coffee and September 15, 2014 "done" high"1 (schedule September 20,2014 "done"" October 1, 2014 invite" meeting) meeting) meeting) "done""medium 1 (schedule "pending""high"1(schedule drinks" Manage Tasks The system is expected to be used on a daily basis. For instance, every day in the morning, employees should be able to do things such as add a task, share a task with other employees, complete tasks, see how far a task has come, change some information about a task (e.g. postpone it), or perhaps write contributions to tasks. One of the challenges that employees face is that they are working on multiple tasks at the same time, and it is hard to know which one is urgent, overdue, etc. The system could help employees by providing an overview of the current tasks that draws the employee's attention to the important tasks. Question: Make an ER model that represents the system. Make sure you show the tables, attributes, relationships and participation. Make assumptions for anything you believe wasn't explicitly mentioned in the text