Proposals, Projects and Donors

The Projects table serves as the core of this database, containing essential information about each project. It tracks the Project Name, Type, Description, and the Start Date and End Date, providing a comprehensive overview of the project’s timeline and purpose. This table ensures that all project details are readily available for review and management.

The Project Donors table is critical for tracking the financial support provided to each project. It links each Donor to a specific Project, records the Date of Donation, and the Amount Donated. This allows for a clear view of each project's funding sources and amounts, which is essential for financial tracking and donor reporting.

The Project Milestones table highlights key deliverables for each project. For each Project, it tracks Deliverable Dates and provides a Deliverable Description. This table helps project managers monitor the project's progress by ensuring that critical milestones are met on time.

The Donors table contains detailed information about each donor, including their Name, Category, and contact information such as Phone and Email. This allows for easy communication and relationship management with each donor, ensuring that they are kept informed and engaged throughout the project lifecycle.

The Proposers table tracks individuals or organizations that propose projects. It includes fields such as the Proposer's Name, Phone, Email, and other contact details. This information is important for identifying and managing relationships with those who initiate new projects.

The Proposals table records all project proposals, tracking the Proposal Name, its Status (e.g., under review, approved, rejected), and the Proposer. It also includes the Proposal Description, along with the proposed start and end dates for the project. This table helps manage the pipeline of potential projects and ensures that all proposals are properly reviewed.

The Staff table holds contact and role information for staff members involved in the projects. It includes the Name, Job Title, Email, and Phone Number, making it easy to identify and reach out to project staff members.

The Project Staff Assignments table links staff members to specific projects, recording each staff member's Role in the project and the Assignment Start Date and End Date. This ensures that staff roles are clearly defined and that project managers can easily track who is responsible for each aspect of the project at any given time.