Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following brief description of operations, create the appropriate

United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following brief description of operations, create the appropriate fully labeled Crows 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. 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.

  • 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.

  • Packing lists produce 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. Each individual package of supplies that is produced by the organization is tracked. Each package is assigned an ID number. The date the package was created, and total weight of the package is recorded.

  • Every packing task is associated with one and only one packing list. Tasks that are not packing tasks are not associated with any packing list. A packing list may not be associated with any tasks or may be associated with many tasks.

  • A given package is associated with one and only one task. Some tasks (e.g., answer the phones) will not have produced any packages, while other tasks (e.g., prepare 5000 packages of basic medical supplies) will be associated with many packages.

  • The actual items included in each package should be tracked. For each item that the organization provides, there is an item ID number, item description, item value, and item quantity on hand stored in the system. A package contains many different items, and a given item can be used in many different packages.

  • Along with tracking the actual items that are placed in each package, the quantity of each item placed in the package must be tracked too. For example, a packing list may state that basic medical packages should include 100 bandages, 4 bottles of iodine, and 4 bottles of hydrogen peroxide. However, because of the limited supply of items, a given package may include only 10 bandages, 1 bottle of iodine, and no hydrogen peroxide. The fact that this package includes bandages and iodine needs to be recorded along with the quantity of each that is included. It is possible for the organization to have items donated that have not been included in any package yet, but every package will contain at least one item.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

More Books

Students also viewed these Databases questions