reate an ERD for given scenario In the current pandemic era, many organizations have been established to collect the donation and provide aid to Covid patients. Let's consider the below scenario related to the same organization: An organization Fighting Covid is established to get donations from the donors for providing various food, medicine, study-related aid to required people. This organization is expanding widely and needs a proper database model to store its donors, donations, and expenses. A donor may make many donations and a donation is used in many helping works e.g. providing medicine to a particular hospital. While donating, a donor may mention the area in which the donation should be used which can be multiple e.g. a donor wants 50% to be used in medical help and 50% to be used to provide food to needy people. The Many to Many relationship is between donation and help area as an area (e.g. food) will have many donations and a donation will have none or many areas (desired by dono
create an ERD for given scenario
In the current pandemic era, many organizations have been established to collect the donation and provide aid to Covid patients. Let's consider the below scenario related to the same organization:
An organization Fighting Covid is established to get donations from the donors for providing various food, medicine, study-related aid to required people. This organization is expanding widely and needs a proper
While donating, a donor may mention the area in which the donation should be used which can be multiple e.g. a donor wants 50% to be used in medical help and 50% to be used to provide food to needy people.
The Many to Many relationship is between donation and help area as an area (e.g. food) will have many donations and a donation will have none or many areas (desired by donor).
E.g. A donation has 1000
Step by step
Solved in 5 steps with 2 images