Problem
Case Study - Fiji Helpers
Fiji Helpers is a non-profit organisation (NGO) that provides aid to people after natural disasters. Due to COVID-19, the focus of Fiji Helpers has been in providing food packs and rations to the affected families in lockdown areas and to families who have lost their income source. The NGO uses volunteers to distribute the packs. Given the sheer volume of requests received, the growing number of volunteers, and the need to keep track of pack distribution, Fiji Helpers has requested your help in developing a system to manage its distribution operations.
The first task assigned to you is to help Fiji Helpers develop a database that should store the following:
• The NGO operates by receiving monetary donations from people and companies. The name and address of the person or company, amount donated, date, medium of donation (cash, cheque, bank transfer) is recorded. A unique id is allocated for each donation.
• Fiji Helpers keeps a record of all volunteers working with the organisation. A new volunteer registers by providing his/her name, address, telephone, and his/her available days in a week for providing volunteer services. A unique id is assigned to each volunteer.
• Fiji Helpers maintains three standard ration pack types - adult pack, children pack, and baby pack. Each pack contains a list of appropriate food items. For each item in the list, the id, name of the product, and quantity are recorded. Each pack prepared is assigned a unique pack id. The date when the pack was prepared is also registered.
• Fiji Helpers has a contract with three suppliers who provide specific food items that are included in the ration packs. The id, name, address, telephone, and email of the supplier are recorded.
• Families requiring assistance call Fiji Helper using a toll-free line. The name of the person who made the call, address, telephone, number of adults (>= 18 years in age), children (4-18 years), and babies in the family are recorded. A unique family Id is assigned to the family. This information allows Fiji helpers to provide appropriate types of ration packs for families.
• Distribution of ration packs is done by volunteers. A volunteer is assigned to deliver ration packs to each family. Appropriate types of ration packs are distributed to families depending on the composition of members in a family. For example, a family with adults and children only will receive the adult and children ration pack types.
Task
Create a Crow's foot ERD showing a possible database design. Show the entities, bridging entities, the relationship between the entities (show the connectivity, cardinality, and strength of relationship), primary and foreign keys, and other attributes.
Note the following options are provided to create the ERD:
A hand-drawn ERD which can be photographed and inserted in this document.