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. Contribution Date/Time Identified 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 Priority parentTask 10 "Find people we need to September 15, 2014 "done" "high" 1 (schedule invite" meeting) 11 "book a room" September 20,2014 "done" "medium" 1 (schedule meeting) 12 "arrange for coffee and October 1, 2014 "pending" "high" 1 (schedule drinks" meeting) 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. Contribution Date/Time Identified 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 Priority parentTask 10 "Find people we need to September 15, 2014 "done" "high" 1 (schedule invite" meeting) 11 "book a room" September 20,2014 "done" "medium" 1 (schedule meeting) 12 "arrange for coffee and October 1, 2014 "pending" "high" 1 (schedule drinks" meeting) 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
