Assume that you have been hired to develop a database to track volunteers who wo
ID: 3710057 • Letter: A
Question
Assume that you have been hired to develop a database to track volunteers who work and raise funds for a local community organization.1. Discuss with explanation data gathering process for the volunteer organization.
2. Discuss how to approach the design of the tables and normalize the data acquired. Assume that you have been hired to develop a database to track volunteers who work and raise funds for a local community organization.
1. Discuss with explanation data gathering process for the volunteer organization.
2. Discuss how to approach the design of the tables and normalize the data acquired. Assume that you have been hired to develop a database to track volunteers who work and raise funds for a local community organization.
1. Discuss with explanation data gathering process for the volunteer organization.
2. Discuss how to approach the design of the tables and normalize the data acquired.
Explanation / Answer
Solution:
1)
The data gathering process will be to gather the data from the volunteers who are working for the cause to raise the fund.
The information which can be gathered are:
Volunteer table:
Community table:
The above fields have some basic details which are like contact number which we can say to be unique and define it as a primary key, name, address, city state is required to know where they are from and then assign the task as per the convenience of the volunteers, this is the reason why education and profession is asked so that the skillset from the volunteers can be managed in a proper way to increase effectiveness.
2)
The design of the database can be designed in such a way that the tables are normalized as independently as possible, the two table which is shown above can be decomposed into more to make it more qualitative.
Like Address table and Donation table for the donors.
The tables need to be normalized into highest form so that the database can provide as much effectiveness as possible.
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)