Describes the ideal contents of each package, Business Management

The following assignment is to be drawn using any software drawing package you have access to (Gliffy, PowerPoint, Visio, etc.). Identify and label all components.

Make sure it is clear and easy to read. Professional quality is expected.

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 Crow's Foot ERD.

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

2. 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."

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

4. Packing tasks result in the creation of packages. 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. A given package is associated with 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.

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

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

Posted Date: 3/28/2013 2:19:02 AM | Location : United States







Related Discussions:- Describes the ideal contents of each package, Assignment Help, Ask Question on Describes the ideal contents of each package, Get Answer, Expert's Help, Describes the ideal contents of each package Discussions

Write discussion on Describes the ideal contents of each package
Your posts are moderated
Related Questions
What is Inventory Control? Inventory Control: Scope and importance of Inventory Control: It is the scientific method of determining how much stock is maintained so as to

Problem 1: (i) (a) Using examples where appropriate, explain the four steps in the control process. (b) Mention the different types of control. Problem 2: Money is a

Question 1: "To inspire confidence and trust leaders must have certain skills which could enable them to comply with Adair's principles" (a) What are the basic skills that

Define the Theory ‘Y’ in human relations. Theory ‘Y’: It is a positive approach to human relations wherein a supervisor integrates the requirements of his subordinates al

Rate, from best to worst, each of the sources you indicate in Question 1 above as being sources you will use in your analysis in terms of its probable reliability. Discuss the ste

QUESTION 1 (a) Explain the various risks faced by an international bank operating in an international market, with emphasis on interest rates and market risks (b) Discuss ho

Compare various types of quality audits, and recommend TWO (2) types of audits suitable for the subject. Explain how those audits can help to assess whether subject's quality effor

Bakery produces muffins and doughnuts. Let x1 be the number of doughnuts produced and x2 be the number of muffins produced. The profit function for the bakery is expressed by the

Explain Offshoring's Value Model of offshoring. Offshoring's Value Model - theory. Four strategies - Strategic sourcing, Commodity sourcing, Value sourcing, Be

Explain the risk-taking capability of an entrepreneur. Risk-Taking Capability: Risk is inseparable and inherent element of entrepreneurship. He supposes about the uncerta