PLZ help with the following: A nonprofit Canadian organization that provides aid to people after natural disasters needs your help to manage their data and to design a database for them using the following business rules: Individuals volunteer their time to carry out the tasks of the organization. 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. The tasks of type “packing” result in the creation of pa
PLZ help with the following:
PLZ help with the following:
A nonprofit Canadian organization that provides aid to people after natural disasters needs your help to manage their data and to design a
Individuals volunteer their time to carry out the tasks of the organization. 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.
The tasks of type “packing” 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.
The packing 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.
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.
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.
The description is not very specific; it only gives a general idea of what’s required. There is no any attribute(s) for volunteers and tasks which is necessary to express the queries and/or transactions mentioned below, you need to add it to the schema and use it in your implementation. In this case, you are free to make any reasonable assumptions that will help you to develop your ERD diagram.
Starting from this general description, do the following initial steps in your database design process:
Question is
-
Create an ER diagram to represent the conceptual database schema for the above scenario.In the diagram, mark the various constraints (the primary keys and the foreign keys of therelations, cardinalities of the relationships, etc.)
-
-
Normalize the relations to 3NF.
-
Step by step
Solved in 3 steps with 1 images
