ASSIGNMENT INFORMATION Points Possible 100 View Rubric Assignment Instructions: For the below case, please answer the following questions: 1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys). 2. Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). Common Assessment Case Study HELP is a voluntary organization that provides aid to people. Based on the following brief description operations, create the appropriate fully labeled Crow's Foot ERD, Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their name, address, and telephone number are tracked. Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment. For each task, there is a task code, task description, task type, and a task status. For example, there may be a task with task code "101,"description of "answer the telephone, a type of "recurring,' and a status of "ongoing." There could be another task with a code of 102,"description of "prepare 5000 packages of basic medical supplies,' a type of 'packing," and a status of "open. For all tasks of type "packing." there is a packing list that specifies the contents of the packages. There are many different packing lists to produce different packages, such as basic medical packages, child care packages, food packages, etc. Each packing list has a packing list ID number, packing list name, and a packing list description, which describes the items that ideally go into making that type of package. Every packing task is associated with only one packing list. A packing list may not be associated with any tasks, or may be associated with many tasks. Tasks that are not packing tasks are not associated with any packing list. By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign services in accordance with the Blackboard Privacy Policy: 2) that your institution may use your paper in accordance with your institution's policies, and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates. ASSIGNMENT INFORMATION Points Possible 100 View Rubric Assignment Instructions: For the below case, please answer the following questions: 1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys). 2. Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). Common Assessment Case Study HELP is a voluntary organization that provides aid to people. Based on the following brief description operations, create the appropriate fully labeled Crow's Foot ERD, Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their name, address, and telephone number are tracked. Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment. For each task, there is a task code, task description, task type, and a task status. For example, there may be a task with task code "101,"description of "answer the telephone, a type of "recurring,' and a status of "ongoing." There could be another task with a code of 102,"description of "prepare 5000 packages of basic medical supplies,' a type of 'packing," and a status of "open. For all tasks of type "packing." there is a packing list that specifies the contents of the packages. There are many different packing lists to produce different packages, such as basic medical packages, child care packages, food packages, etc. Each packing list has a packing list ID number, packing list name, and a packing list description, which describes the items that ideally go into making that type of package. Every packing task is associated with only one packing list. A packing list may not be associated with any tasks, or may be associated with many tasks. Tasks that are not packing tasks are not associated with any packing list. By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign services in accordance with the Blackboard Privacy Policy: 2) that your institution may use your paper in accordance with your institution's policies, and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates
