Assume that you have been hired to develop a database to track volunteers who wo
ID: 3709883 • 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 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 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 data gathering process for the volunteer organization.
2. Discuss how to approach the design of the tables and normalize the data acquired.
Explanation / Answer
1. Discuss data gathering process for the volunteer organization.
To gather data, we need to lock for different source (i) local communit databases/physical records, (ii) By interviewing local candidate, (iii) creating portal for volunteers to register
2. Volunteer details need at least following fields:
ID (assigned)
Name
Contact information (Address, age, mobile)
Community organization
Other tabel needs details
id
funds raised
date