The Donors table stores information about individuals or entities who contribute to the organization. It includes personal and contact details, donation categories, annual pledges, and donation history over the past four years. This table helps maintain a comprehensive profile of each donor, track their total contributions, and understand their giving patterns.
The Donations table records each donation made to the organization. It includes details such as the donation number, donor's name, date of donation, amount, category, payment method, and a description of the donation. This table is essential for tracking all incoming funds, ensuring accurate records of all donations, and providing transparency in financial reporting.
The Receipts table is used to generate receipts for donors, summarizing their total donations for a specific year. It includes donor information, total donation amount, receipt number, and other relevant details. This table ensures that donors receive proper acknowledgment for their contributions and can use the receipts for tax purposes.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.