How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask TheDoctor Your Own Question
TheDoctor, Software Engineer
Category: Programming
Satisfied Customers: 1757
Experience:  M.S. in Internet Information Systems
Type Your Programming Question Here...
TheDoctor is online now
A new question is answered every 9 seconds

I have another one if your up for it...Its a long one... United

This answer was rated:

I have another one if your up for it...It's a long one...
United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following description of operations, create the appropriate fully labeled Crow’s Foot ERD.
Volunteer carry out the tasks of the organization. The name, address, and telephone number are tracked for each volunteer. Each volunteer may be assigned to several tasks, and some tasks require many volunteers. A volunteer might 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.

Each task as a task code, task description, task type, and task status. For example, there may be a task with task code “101” a description of “answer the telephone” a type of “recurring”, and a status of “ongoing.” Another task might have a code of “102” a description of “prepare 5,000 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 packing lists to product different packages, such as basic medical packages, child-care packages, and food packages. Each packing list has an ID number, a packing list name, and a packing list description, which describes the items that should make up the package. Every packing type is associated with only one packing list. A packing list my not be associated with any task, or it may be associated with many tasks. Tasks that are not packing tasks are not associated with any packing list.

Packing tasks result in the creation of packages. Each individual package of supplies produced by the organization is tracked, and each package is assigned an ID number. The date the package was created and it’s total weight are recorded… A given package is associated with only one task. Some tasks (such as “answer the phones”) will not produce any packages, while other tasks (such as “prepare 5,000 packages of basic medical supplies”) will be associated with many packages.

The packing list describes the ideal contents of each package, but it is not always possible to include the ideal number of each item. Therefore, the actual items included in each package should be tracked. A package can contain many different items, and a given item can be used in many different packages.

Each item that the organization provides has an item ID number, item description, item value, and item quantity on hand stored in the system. Along with tracking the actual items that are placed in each package, the quantity of each item placed in the package must be tracked as well. 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 the package includes bandages and iodine needs to be recorded along with the quantity of each item included. It is possible for the organization to have item that have not been included in any package yet, but every package will contain at least one item.
Hello and thank you for requesting me.

By when is this required?
Customer: replied 4 years ago.
I need it by Sunday at 9XXXXX
Then you shall have it before Sunday, 9:00am CT.
Customer: replied 4 years ago.
Great!! Thanks so much!
You are welcome. I will contact you once it is complete.
Customer: replied 4 years ago.
Sounds good!
Hello, You can download the file here:

I included a description of each relationship. Let me know if you have any questions.

If you need assistance with future questions, please start the question with **For TheDoctor** if you wish to work with me directly. It would be my pleasure to assist you further.

Please remember to rate my answer.

Thank you so much for using JustAnswer.
TheDoctor and other Programming Specialists are ready to help you

Related Programming Questions