Answer Happy

**
KiwiVision is a non-profit organisation that provides aid to people after natural disasters. • Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their name, address, and telephone number are stored. 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 exist without being assigned any task. It is possible to have a task to which no one has been assigned to as yet! When a volunteer is assigned to a task, the start time and end time of that assignment must be recorded. • For each task, there is a task code, task description, task type, and a task status. For example, there may be a task with a code of “101,"description of “prepare 500 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, childcare 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. • Packing tasks result in the creation of packages. Each individual package of supplies that is produced by the organization is also stored. Details such as the identification number for each package, the date the package was created, and total weight of the package are recorded. A given package is associated with only one task. Some tasks will not have produced any packages, while other tasks (e.g., "prepare 500 packages of basic medical supplies") will be associated with many packages. • It is not always possible to include the ideal quantity specified for each item in the packing list when creating a package. Therefore, the quantity of actual items included in each package must be tracked. A package can contain many different items, and a given item can be used in many different packages. • For each item that the organization provides, details of item ID number, item description, item value, and item quantity on hand must be recorded. Note: It is recommended that you use Visual Paradigm to develop your ERD. However, you can also create handwritten diagrams and capture pictures of your diagrams. Please make sure that your diagram is readable, has clear layout and format and the following requirements are shown clearly. Based on the information in the case study above, create a logical Entity-Relationship (ER) Diagram using the Crow's foot model symbols and include all attributes. Your diagram must: (a) Identify all possible entities and relationships. (8.5 marks) (6) Identify the main attributes in each entity including all primary and foreign keys (7.5 marks) (C) Identify the cardinality and participation (mandatory/optional dependencies) for all the relationships (6 marks) (d) Resolve all M:N relationships (4 marks)